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

excel

ResolvedVersion 2003

Tina has attended:
Excel Intermediate course
Excel Advanced course

Excel

How do you track changes in multiple woorksheets?

RE: Excel

Hi Tina,

Thanks for your question and welcome to the forum.

You can watch changes in multiple worksheets using the Watch Window.

The Watch Window can be found on the Formula and Auditing toolbar found under either View, Toolbars or Tools, Formula and Auditing, Show Formula Auditing Toolbar.

Select the cell you want to watch and Add Watch, repeat for all cells you want to track on any sheet.

Thanks and kind regards

Maggie

Excel

My excel colums hace changed from letters to number. How do I change it back to letter?

Excel tip:

Switch between workbooks ni EXCEL.

use Alt-TAB to switch between workbooks.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.