Useful Keys

Microsoft Word

Ctrl+Delete – allows you delete entire words in one keystroke

Ctrl+D – brings up the font window allowing you to select the important “subscript” and “superscript” effects. Especially important for lab reports with all those damn chemical and mathematical equations. Then again, you could simply add the subscript and superscript buttons to your toolbar.

Holding shift allows you highlight text as if you were using a mouse. (This was really useful in high school, when an essay was due except my mouse was broken)

Microsoft Excel

Split screen - allows you split the screen.

Freeze panes - freeze panes allows you *always* see certain cells.

Auto filtering - self explanatory. It filters your stuff.

Watch window

1. Select the cells you want to watch.

To select all cells on a worksheet with formulas, click Go To on the Edit menu, click Special, and then click Formulas.

2. On the Tools menu, point to Formula Auditing menu, and then click Show Watch Window.
3. Click Add Watch .
4. Click Add.
5. Move the Watch Window toolbar to the top, bottom, left, or right side of the window.
6. To change the width of a column, drag the boundary on the right side of the column heading.
7. To display the cell that an entry in Watch Window toolbar refers to, double-click the entry.