excel.advanced.course - auto filters

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 » excel.advanced.course - Auto filters

excel.advanced.course - Auto filters

resolvedResolved · Low Priority · Version Standard

Nina has attended:
Excel Introduction course
Excel Intermediate course

Auto filters

How would i use filters on the whole spread sheet using my own criteria?

Edited on Wed 16 Jan 2008, 12:29

Filtering Using Criteria

Hi Nina

If you have a list of records it is possible to extract all records that meet a specified set of criteria and place them elsewhere in your worksheet.

For example in a list of customer details you could find all customers who live in


 

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips


Server loaded in 0.07 secs.