Instructions for Deleting Empty Lines and Columns in Excel 2016

This article examines Excel 2016 and explains the main developments, practical implications, and context readers should understand.

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.

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.

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.

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:

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

• Instructions for installing and using Office 2016

• How to change the default save file format in Word, Excel and PowerPoint 2016?

Good luck!