what are the features of auditing in ms excel 2003?
 

what are the features of auditing in ms excel 2003?
 

Homework?

--
Don Guillett
SalesAid Software

"laxminabard" wrote in message
...

what are the features of auditing in ms excel 2003?
 

Sounds like it, doesn't it? ;-)

--

JoAnn Paules
Microsoft MVP - Publisher

How to ask a question
http://support.microsoft.com/kb/555375



"Don Guillett" wrote in message
...
Homework?

--
Don Guillett
SalesAid Software

"laxminabard" wrote in message
...

what are the features of auditing in ms excel 2003?
 

Watch a formula and its result

Watch cells and their formulas (formula: A sequence of values, cell
references, names, functions, or operators in a cell that together produce a
new value. A formula always begins with an equal sign (=).) on the Watch
Window toolbar (toolbar: A bar with buttons and options that you use to carry
out commands. To display a toolbar, click Customize on the Tools menu, and
then click the Toolbars tab.), even when the cells are out of view.

Watch Window toolbar

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.

On the Tools menu, point to Formula Auditing menu, and then click Show Watch
Window.

Click Add Watch .

Click Add.

Move the Watch Window toolbar to the top, bottom, left, or right side of the
window.

To change the width of a column, drag the boundary on the right side of the
column heading.
To display the cell that an entry in Watch Window toolbar refers to,
double-click the entry.

Note Cells that have links (external reference: A reference to a cell or
range on a sheet in another Excel workbook, or a reference to a defined name
in another workbook.) to other workbooks are displayed in the Watch Window
toolbar only when the other workbook is open.