Working with mulitple worksheets

Resolved · Low Priority · Version 2003

Tue 17 Feb 2009, 16:50 Delegate Joan said...

Joan has attended:
Excel Introduction course
Excel Intermediate course
Word Intermediate course
Outlook Advanced course
PowerPoint Introduction course

Working with mulitple worksheets

How do I add a watch window

Wed 18 Feb 2009, 10:52 Trainer Amanda said...

RE: Working with mulitple worksheets

Hello Joan

Thank you for your question.

To add a watch window to a cell containing a formula:

1. Select the cell.
2. Go to Tools - Formula Auditing - Show Watch Window.
3. Click the Add Watch button in the Watch Window.

Kind regards
Amanda

Tue 24 Feb 2009: Automatically marked as resolved.

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips

Working with mulitple worksheets

Working with mulitple worksheets

RE: Working with mulitple worksheets

Excel articles

Excel tip:

Enter formulae into multiple cells