| Build Alarms into Your Model |
|
|
| Build Alarms into Your Model |
|
|
Need to know right away when you reach your target or when your budget falls outside an acceptable range? You can use special formatting for values that meet the conditions you specify.
|
Prevent false
alarms It’s easy to type an extra
zero now and then, so make sure you don’t set off
your alarms because of incorrect data entry. Use validation
to ensure that values are within specified limits.
Select data-entry cells and click Validation (Data
menu). For more information, see Validate Your Data as You Enter It.
Create hyperlinks to source data Important data often deserves further explanation—especially when an alarm is triggered. Click the Insert Hyperlink button to create a hyperlink that jumps directly to a cell range, worksheet, or workbook containing additional information. You can even create a hyperlink to information located on the World Wide Web, or to documents created in other Office applications. For more information, see Publish Microsoft Excel Tables and Charts on the Web. |
<< Previous Topic | < Previous Page | Next Page > | Next Topic >>
©1996 Office Getting Results Book.
©1997 Microsoft Corporation. All rights reserved.
Legal Notices.
Insert
Hyperlink button