Wednesday, November 23, 2011

How to Remove Blank Cells in Excel 2007


1. Select the range of cells that contains blanks to remove.
2. Click 'Find Select,' at the far right of the Home tab.
3. Choose 'Go to Special....'
4. Click the 'Blanks' radio button in the resulting window.
5. Click 'OK' to close the window and highlight all blank cells in the selected range.
6. Click the 'Delete' arrow button on the Home tab and choose 'Delete Cells....'
7. Choose an option for filling in the blanks: Shift cells left or up, or delete entire rows or columns.

Blogger news