auto 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 » Auto filtering

Auto filtering

resolvedResolved · Low Priority · Version Standard

Caroline has attended:
Excel Intermediate course

Auto filtering

How do I filter information on the worksheet?

RE: Auto filtering

You can select either an entire row or highlight several column headers. Then go to data, filter and Auto Filter. This will put the filer on the headings


 

Excel tip:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips


Server loaded in 0.1 secs.