excel inrermediate

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Inrermediate

Excel Inrermediate

resolvedResolved · Low Priority · Version 2007

Caroline has attended:
Excel Intermediate course

Excel Inrermediate

this is a dummy question

RE: Excel Inrermediate

Hello Caroline

Thank you for your post.

By logging into your delegate account on our web site, you will be able to access and post questions through to our support forum, any time within the next 12 months.

Kind regards
Best Training


 

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips


Server loaded in 0.09 secs.