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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel course london - multiple filter columns

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course london - Multiple filter columns

excel course london - Multiple filter columns

ResolvedVersion Standard

James has attended:
Excel VBA Intro Intermediate course

Multiple filter columns

Can I multi select and filter on columns??

RE: Multiple filter columns

yes.

Hold the shift key when selecting multiple inclusive cells, columns or rows.

Multiple filtering = add upto 2 criteria with custom autofilter, or use advanced filter for more options.

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

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