How to Remove Blank Rows in Excel

Written by gregory hamel
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel is a popular spreadsheet program that is used extensively in business and finance settings to store, organise and perform calculations on data. One of the most basic functions of Excel is organising data by eliminating rows or cells that are not needed, such as blank rows between rows of data. There are several different ways to delete blank rows; the most efficient method will depend on how many rows you have to remove.

Skill level:
Moderately Easy

Other People Are Reading

Things you need

  • Computer
  • Microsoft Excel

Show MoreHide

Instructions

    Deleting A Small Number of Rows

  1. 1

    Save your spreadsheet.

  2. 2

    Hold the "Control" key.

  3. 3

    Left-click the number of each blank row you want to delete to highlight each one. Make sure you continue holding "Control" down as you select the rows.

  4. 4

    Right-click on one of the highlighted rows and select "Delete."

    Deleting Many Blank Rows

  1. 1

    Save your spreadsheet.

  2. 2

    Press the F5 key, then click "Special."

  3. 3

    Select "Blanks" and press "OK."

  4. 4

    Click "Home," then "Delete" under the cell options. (Or click "Edit" and "Delete" for older versions of Excel) Note that using this method will remove all blank cells and move the data up, so if there are different blank fields in some rows it may cause data to become disorganised. Always save your spreadsheet before performing operations so you can revert back to old versions if necessary.

    Removing Blanks by Sorting

  1. 1

    Save your spreadsheet.

  2. 2

    Highlight all the cells that you want to sort.

  3. 3

    Click "Data," then "Sort."

  4. 4

    Under "Sort By," select "Column A," then click "OK." This will sort the data by the values in column A, leaving any rows without data values for column A at the bottom of the sorted list, essentially deleting them.

Tips and warnings

  • If you make a mistake while deleting cells, you can hold "Control" and then press the "Z" key to undo your last action. You can continue pressing "Z" while holding "Control" to undo more actions.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.