Difference between revisions of "Office 2007"
From Richard's Wiki
| Line 12: | Line 12: | ||
** Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected. | ** 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. | ** Now choose Edit, Delete, select the Entire Row option and click OK. | ||
| + | |||
| + | ===== Microsoft Word ===== | ||
| + | * [http://support.microsoft.com/kb/290953 How to number chapters, appendixes, and pages in documents that contain both chapter and appendix headings in Word] | ||
Revision as of 18:46, 15 June 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.
