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

excel

ResolvedVersion 2003

Marjorie has attended:
Excel Intermediate course

EXCEL

I've applied the data filter on an excel spreadsheet how do I highlight all the items on the spreadsheet in one go rather than highlighting them individually

RE: EXCEL

Hi Marjorie, thanks for your query. You can select all items on a spreadsheet either by CTRL+A or by clicking on the grey rectangle at the intersection of the row and column headings on the top left hand side of the worksheet.

Hope this helps,

Anthony

Wed 4 Aug 2010: Automatically marked as resolved.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.