Filtering in Excel 2007

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?
 
C

Colin3440

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.
 
G

Gord Dibben

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
Changing Excel default highlighting 2
Need help deleting data 2
filter rows with shaded cells 1
Highlighting rows/columns is there a way to darken the highlight? 1
I can't see totals in status bar when I highlight cells 3
Faint cell highlighting in Excel 2007 4
Active cell/row highlighting 2

Top