How do I delete blank rows in Excel 2016?

Excel 2016 – How to delete empty rows

1. With your spreadsheet open, press F5 on the keyboard.
2. Click on the ‘Special’ button.
3. Click on ‘Blanks’ then click ‘OK’
4. This will select all the empty fields within your table.
5. In the ‘Home’ ribbon, click on the arrow below the ‘Delete’ button then click on ‘Delete Sheet Rows’

How do you delete extra rows in Excel that go on forever?

Now we can delete rows or columns in excel that go on forever with keyboard shortcut Ctrl – or by right-clicking on the selected cells and pressing Delete.

Why does my Excel have so many empty rows?

The most common cause of the last cell being set outside the worksheet range that is currently in use is excessive formatting. When you format whole rows and columns, some types of formatting can cause the last cell to be set to a cell far below or to the right of the actual range that is in use.

How do you delete blank rows in Excel?

Press[F5].

In the resulting Go To dialog box, click Special.

Click the Blanks option and click OK. Doing so selects the blank cells (what you might think of as rows) in the selected…

Now you’re ready to delete the selected cells. On the Home tab, click the Delete dropdown in the Cells group and choose…

How to properly delete blank rows in Excel?

Delete Blank Rows Excel On the Home tab, in the Editing group, click Find & Select. Click Go To Special. Select Blanks and click OK. Excel selects the blank cells. On the Home tab, in the Cells group, click Delete. Click Delete Sheet Rows. See More….

How do you remove blank rows?

The simplest way to delete/eliminate blank rows is to select the blank rows manually. This may take a long time in big spreadsheets, as you have to target them manually. In this process, select the blank row by just putting the mouse cursor in the leftmost side of a row and clicking the right button of the mouse.

How can I print worksheet excluding blank rows?

Hold down the ALT+F11 keys to open the Microsoft Visual Basic for Applications window.

Click Insert > Module,and paste the following code in the Module Window.

Then press F5 key to run this code,and a prompt box will pop out to remind you select the data range that you want to print,see screenshot: