Filtering in Excel 2007

  • Thread starter Thread starter Colin3440
  • Start date Start date
C

Colin3440

I would like to filter out all of the rows that have a certain color
highlighting in any of their cells. How would I do this?
 
I have a lot of columns in my document and I don't want to have to go through
each one and select "filter by color." I want to be able to filter all of the
columns at the same time.
 
Select all cells by clicking on the button at top left intersection of rows
and columns or hit CTRL + a

Edit>Find>Format>Format

Select your color from the Patterns Tab.

Then Find All and CTRL + a which selects all the "founds" on the sheet.

Format>Row>Hide.


Gord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 compatibility issue - speed between cells 2
How do I filter the cells based in Fill color? 2
How to filter rows data based on background color of individual cells 1
Date filters in List for Excel 2003? 1
MS Excel Filters 1
Filter by Format 1
Filter certain cells 1
Need help deleting data 2

Back
Top