excel

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 2003

Excel 2003

resolvedResolved · Low Priority · Version 2003

Marco has attended:
Excel Intermediate course

Excel 2003

How do I use auto-filter?

RE: excel 2003

Hi Marco

Thank you for your question and welcome to the forum.

To set up auto filter:
1. Select a cell in the data area
2. Go to Data - Filter - AutoFilter.
Dropdown arrows will appear at the top of each column.

You can use the Auto Filter arrows to select a single item from a particular column, or use the Custom Filter option to access additional options (e.g. selecting two different items, selecting items that are over or under a certain amount).

Amanda


 

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips


Server loaded in 0.08 secs.