::: Excel tips 13 :::

>> Catching data entry errors <<

It's a fact: Shared workbooks generate more errors than workbooks with only one owner. Here's one way to flag errors as they occur:
. Select all cells in which data will be entered.
. Go to Format | Conditional Formatting.
. In the Conditional Formatting dialog box, specify which cell values to flag.
. Click Format.
. In the Format Cells dialog box, click the Patterns tab and select a color to signal errors.
. Click OK.
Now, when someone enters an error, it will be flagged with your selected color.

----------------------------------------------------------------------

>> Quickly setting a print area <<

Your users probably waste a lot of time and paper sending entire worksheets to the printer when all they need is a printout of a few columns or rows. Teach them this quick trick to set specific print areas within the Print Preview mode:
. Select View | Page Break Preview.
. Select the cells you want to print.
. Right-click on the selection and choose Set Print Area from the shortcut menu.
. Click Print.