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

excel

ResolvedVersion 2003

Katie has attended:
Excel Introduction course
Excel Introduction course
Excel Intermediate course

Excel

how do i auto filter

RE: excel

Hi Katie.

Welcome to the forum.

Click the column you want to filter, then go to Data -> Filter -> Autofilter.

You will then be able to use the drop down box at the top to filter your column.

I hope this answers your question.

Regards, Rich

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

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.09 secs.