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

microsoft+excel+training - auditing worksheet

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - Auditing a worksheet

microsoft+excel+training - Auditing a worksheet

ResolvedVersion Standard

Seema has attended:
Excel Intermediate course

Auditing a worksheet

How do you open the formula auditing toolbar?

RE: Auditing a worksheet

Hi Seema. Very simply you select Tools - Toolbars and then make sure Formula Auditing is selected.

Hope this helps,

Anthony

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

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.