what are the features of auditing in ms excel 2003?

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top