filters

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

Train Strikes - 7th, 12th Nov 2024

Hide

Contact Us About Resources Sign in

Solutions Through Learning

Excellent

Request Callback We will call you back 0207 987 3777 Call for assistance Your Basket Basket is empty

Solutions Through Learning

Callback

Sign in

Basket

Menu

Call us on 0207 987 3777 or Search our website

Courses
- Application Training
  - Excel
    - All Excel
    - Introduction
    - Intermediate
    - Advanced
    - Advanced - Formulas & Functions
    - Advanced - For Power Users
    - VBA
    - VBA Introduction
    - VBA Intermediate
    - VBA Advanced
    - Charting
    - Dashboards for Business Intelligence
    - Advanced Excel Dashboards
    - Forecasting & Data Analysis
    - Power Query
    - PivotTables
    - PowerPivot
    - Financial Modelling
    - Excel for Finance Professionals
  - Microsoft Office 365
    - 365 Adoption Program
    - 365 Explained
    - 365 Ambassadors
    - 365 End Users
    - OneNote
    - Teams
  - ChatGPT
  - Power Automate
  - Power BI
  - Powerpoint
  - Access
  - Word
  - MS Project
  - Sharepoint
  - Outlook
  - Visio
  - View all 200+ Courses
- Productivity Training Programs
- Professional Development
  - All Professional Development
  - Taking Minutes
  - Time Management
  - Organisational Skills
  - Negotiating Skills
  - Presentation Skills
  - Effective Communication Skills
  - Assertiveness At Work
  - View all 50+ Courses
- Management Training
  - All Management Training
  - Introduction to Management
  - Managing Teams Remotely
  - Mentoring
  - Managing Change
  - Leadership Development
  - View all 50+ courses
- Sales & Customer Service
  - All Sales & Customer Service
  - Customer Service Excellence
  - Excellent Account Management
  - Fundamentals of Selling
  - Selling Skills Programme
  - View all 20+ courses
- Financial Training
  - All Financial Training
  - Finance for Non Financial Managers
  - Effective Budgeting and Beyond
  - View all Courses
- Project Management
  - All Project Management
  - Project Management course
  - Microsoft Project
  - PRINCE 2 Foundation
  - PRINCE 2 Practitioner
  - View all 18+ courses
- eLearning Solutions
Promotions
- Promotions
- Excel Courses London
Schedule
- Public Schedule
- How to Book
- Reschedule
- Last Minute Deals
- What to Expect
- Venues and Equipment Hire
- Industry Leading Pricing model
Formats
- All Formats
- Public Scheduled Courses
- On-Site Training
- Productivity Training Programs
- Closed Company Events
- Online Classroom (Virtual)
- Consultancy
- One to One Training
- Training Needs Analysis
- Floor Walking
- Roll Out
- E Learning
- Executive Coaching
Our Clients
- Client List
- Online Reviews
- Client Testimonials
- Client Feedback
- Featured Case Studies
Contact Us
About us
Resources
Your account
Sign in

Home » Resources » Forum

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

Filters

Resolved · Low Priority · Version 2003

Thu 24 Sep 2009, 16:16 Delegate Simon said...

Simon has attended:
Excel Intermediate course

Filters

How do you turn on filters ?

Fri 25 Sep 2009, 16:50 Trainer Andrew said...

RE: filters

Hi Simon

Thank you for your question. To turn on auto-filter click in your table of records then from the Data menu choose Filter > Autofilter

I hope this helps - do let us know if you have any further requirements.

Kind regards,
Andrew

Fri 2 Oct 2009: Automatically marked as resolved.

Excel tip:

Move to edge of data block

When data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5 2224 reviews