Difference between revisions of "Office 2007"
From Richard's Wiki
| Line 4: | Line 4: | ||
outlook.exe /resetnavpane | outlook.exe /resetnavpane | ||
</code> | </code> | ||
| + | * 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. | ||
Revision as of 23:03, 29 March 2010
- Quick Reference Card - Up to speed with the 2007 Microsoft® Office system
- If Outlook 2007 comes up with a message saying "Cannot create Outlook window", a possible fix is to run the following from the command line:
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.
