watch window

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Watch window

Watch window

resolvedResolved · Low Priority · Version 2003

Sjoerd has attended:
Excel Intermediate course

Watch window

in what kind of situation could I best use the 'watch cell' option?

RE: watch window

Hi Sjoerd

Thanks for your question. You might add a watch to a cell so you can track changes to the contents of the cell whilst you work in a different part of the workbook that means the destination cell is no longer visible on the screen.

I hope this helps - let us know if you have any further questions.

Kind regards,
Andrew


 

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips


Server loaded in 0.08 secs.