Pages

Thursday, February 9, 2012

EXCEL, WORD, OFFICE HELP


EXCEL
WORD
OFFICE
Spell check all sheets in a workbook at once. If a workbook contains several sheets, you probably spell check each sheet individually. However, you don't have to. If you'd like to spell check an entire workbook, first right-click on any sheet tab, and then choose Select All Sheets from the resulting shortcut menu. To spell check specific sheets, hold down the [Ctrl] key and click on the appropriate sheet tabs, or hold down the [Shift] key to select a block of adjacent worksheets. After you've made your selection, simply press [F7] to launch the spell checker.





Eliminate single words at the bottom of the page.  Do you have a single word left at the bottom of a page or only one word on the following page?  These are called orphans and widows, respectively.  Quick fix:  right click on any part of the paragraph and select Paragraph.  On the “Line and Page Breaks,” tab check to see that Widow/Orphan control is checked.  If you’re trying to keep a title with its paragraph or a diagram with its referring paragraph, try checking Keep with next and/or Keep lines together to solve the problem.

OFFICE 2007-2010 takes some getting used to even with all of the great new features.  The most common frustration is “Where did they put my icons?!”  The ribbon is basically organized “most commonly used” to “least commonly used”, left to right.  However, it may still take you some time to locate a button or icon.  As soon as you do, if it is one you use frequently, right-click on it and choose Add to Quick Access Toolbar.  It is now on the small toolbar in the far upper-left corner of the screen.