Monday, September 24, 2012

How to Remove Blank Rows in Excel


Deleting A Small Number of Rows
1. Save your spreadsheet.
2. Hold the 'Control' key.
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. Right-click on one of the highlighted rows and select 'Delete.'
Deleting Many Blank Rows
5. Save your spreadsheet.
6. Press the F5 key, then click 'Special.'
7. Select 'Blanks' and press 'OK.'
8. 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 disorganized. Always save your spreadsheet before performing operations so you can revert back to old versions if necessary.
Removing Blanks by Sorting
9. Save your spreadsheet.
10. Highlight all the cells that you want to sort.
11. Click 'Data,' then 'Sort.'
12. 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.

Blogger news