filtering

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Filtering

resolvedResolved · Medium Priority · Version 2003

Kirsty has attended:
Excel Introduction course

Filtering

How do you add a filter to a column?

RE: filtering

Hello Kirsty

Thank you for your question and welcome to the forum.

The most simple way to be able to filter a column is using AutoFilter.

To show an AutoFilter dropdown next to a column, select a cell within the column which has some data in it; then go to Data - Filter and choose AutoFilter.

Filtering is covered as part of our Excel Intermediate course.

Kind regards
Amanda

Wed 10 Dec 2008: Automatically marked as resolved.


 

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.08 secs.