Office 2007

From Richard's Wiki
Revision as of 23:03, 29 March 2010 by Rkdrm (Talk | contribs)

Jump to: navigation, search

outlook.exe /resetnavpane

  • To delete blank rows in Excel:
    • First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data .
    • Now, select the cells in one column from the top of your list to the bottom.
    • Make sure that all the blank cells in this selected range are the rows you want to delete.
    • Press the F5 key on your keyboard (or select Edit, Goto).
    • Click the Special button.
    • Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
    • Now choose Edit, Delete, select the Entire Row option and click OK.