Tips and Tricks for Office
- When working with an Excel spreadsheet, it is sometimes difficult to find all the cells that contain your formulas. It is easy to view all formulas at once if you use the keystroke control-` (` is the key above Tab). Use this keystroke combination again to return to the normal view. When using this, you'll notice that columns are temporarily made wider so that it's easier to see your formulas.
- Often when creating a Word document, it's confusing to try to remember where you've placed tabs, returns, spaces, etc. You can see these by using the Show/Hide button on your toolbar (
). Spaces, tabs and returns are shown.
- You can use Word to type data into a form by first scanning the form and then using that as the watermark. You'll have to keep changing the line spacing come out correctly, but if you don't have a typewriter (who does anymore) and the form needs to be typewritten, it's a good solution.
- Don’t overlook Conditional Formating in Excel. Using this feature you can specify the fill color (background color) for cells based on criteria such as whether or not the cell value is positive or negative. To use this, first select a cell or range of cells, then click on Format, and then Conditional Formating. In the dialog box, specify your condition and then the formatting to use if that condition is met.
- If you get a lot of junk email in Outlook and want to delete several emails at once, hold down the control key and click on each email to be deleted. Then click on the delete symbol on the toolbar (or right click and chose delete). This puts the selected emails into the Deleted Items folder which you’ll have to empty later. If, however, you hold down the Shift key while deleting, the email gets deleted without going through the delete folder.
