Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Working with mulitple worksheets

Working with mulitple worksheets

ResolvedVersion 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:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Working with mulitple worksheets

Working with mulitple worksheets

RE: Working with mulitple worksheets

Excel articles

Excel tip:

No Zeros