How can i remove blank lines in excel

IT solutions for today's CPAs. For more information and to view an archive of previous Tech Tips, please visit us here. Do you have specific topics you would like to see covered in Tech Tips? Email any suggestions to communications ficpa. Email : msc ficpa. Click Special to display the Go To Special dialog box. Excel will select all of the blank cells within the selected range. Right-click one of the selected blank cells and select Delete. Select Entire Row. Deleting blank rows using filtering You can also delete blank rows using filtering traditionally called AutoFiltering.

To delete blank rows using Filter: Select the range of cells that includes all of the data in the data set including blank rows. Arrows appear beside the field names. Click the arrow beside the field name with the blank cells in rows you want to delete.

Turn off or de-select Select All. Select Blanks. You will likely need to scroll down to select Blanks. Select the row headings of the filtered rows by clicking the first row heading and Shift-clicking the last row heading.

Right-click one of the selected headings. Select Delete Row. In the example below, the Promotion field is filtered to display blanks: You will now be able to sort, filter and create pivot tables with the list. Subscribe to get more articles like this one Did you find this article helpful? You may also like. Avantix Learning Team. Publisher Name. World globe An icon of the world globe, indicating different international options.

Get the Insider App. Click here to learn more. A leading-edge research firm focused on digital transformation. Good Subscriber Account active since Shortcuts. Account icon An icon in the shape of a person's head and shoulders.

It often indicates a user profile. The row will disappear, and you can move onto deleting the next blank row! Before we do, you should grab the free exercise file so you can follow along. Kasper Langmann , Co-founder of Spreadsheeto. The best way to learn how to delete blank rows in Excel is to do it yourself. Select the radio button next to Blanks :. But this option has a fatal flaw: it deletes rows with ANY blank cells in them. Click Delete Sheet Rows to see what I mean. Using the next method gets better results.

As you can see, this leaves a few rows that have blanks in column A but data in other rows.