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
 

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
Filter by Format 1
MS Excel Filters 1
Filter certain cells 1
Delete Filtered Rows in Excel 2007 7

Back
Top