Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Filtering

Resolved · Low Priority · Version 2007

Reply Tue 18 Jan 2011, 16:05Delegate Sally said...

Sally has attended:
Powerpoint Intermediate Advanced course
Excel Intermediate course

Filtering

How do you filter colours

For upcoming training course dates see: Pricing & availability

Reply Wed 19 Jan 2011, 16:39Trainer Nafeesa said...

RE: Filtering

Hi Sally

Thank you for your question.

Once you have applied the relevant colours to the cells either manually using the 'Fill Colour' button or by using Conditional Formatting:

- Select one of the cells in the data set

- Open the the Data tab (at the top of the interface on the Ribbon)

- Select the 'Filter' button to apply the AutoFilter (drop-down arrows)

- click the AutoFilter drop-down arrow on the data set that has the colours

- You should be able to see an option that says 'Filter by Colour'

- Select the relevant colour to filter by.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.

Regards,

Nafeesa

Microsoft Office Specialist Trainer

Reply Wed 19 Jan 2011, 16:39Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Wed 26 Jan 2011: Automatically marked as resolved.

Excel articles

· Advanced Excel and PivotTable Reports
· How Excel Can Transform All Of Your Office Documents
· Inviting Investment Into Your Business Can Be Easier With Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Sorting Birthdates Into Their Respective Months In Excel

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips