Instructions for deleting empty lines and columns in Excel 2016

Sometimes your spreadsheet has too many blank lines and empty columns look very messy and lose aesthetics. To make the spreadsheet look better you can delete these blank lines and blank columns. However, instead of manually deleting each column, each blank line is very time-consuming, especially with long spreadsheets with many empty columns and empty lines.

In the following article, Network Administrator will guide you how to delete empty lines and columns on Excel 2016 quickly to help you save a lot of your "precious" time.

Instructions for deleting empty lines and columns in Excel 2016 Picture 1

Delete blank lines and empty columns in Excel 2016:

To delete blank lines or empty columns in Excel, first black out the range of data containing blank lines and blank columns.

Next under the Home tab select Edit group and then click Find & Select.

Instructions for deleting empty lines and columns in Excel 2016 Picture 2

Next open your spreadsheet and then press the F5 key repeatedly to open the Go To window.

When the Go To window appears, click the Go To Special option.

Check the Blank checkbox and click OK .

At this point you will see Excel arranging blank lines, empty columns adjacent to the spreadsheet. This makes it easy to delete empty lines and columns you want.

To delete blank lines, empty columns, select the rows in the row or column you want to delete, then from the Home tab, in the Cells group section, click Delete .

Instructions for deleting empty lines and columns in Excel 2016 Picture 3

So, you have completely deleted blank lines and empty columns on your Excel spreadsheet.

Now your spreadsheet looks much more beautiful.

Refer to some of the following articles:

1. Instructions for using Pareto, Histogram and Waterfall charts in Excel 2016

1. Instructions for installing and using Office 2016

1. How to change the default save file format in Word, Excel and Powerpoint 2016?

Good luck!