Autofilter query?

M

Me!

A colleague has a problem whereby when he colours selected rows when the
Autofilter is on, and then removes the filter, not only his selected rows
are coloured - a large selection is coloured.

We are using XL 2007 and this behaviour does not happen when I try to
replicate it.

Can anyone advise?
 
B

Bernie Deitrick

Me!,

One way around this (not sure why it is happening) is to use the 2007 equivalent of Edit / Go to..
Special Visible Cells only (not sure of the exact steps to do that in 2007) prior to coloring
the cells.

HTH,
Bernie
MS Excel MVP
 

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 autofilter freezes 0
Autofilter problem 9
Autofilter not capturing all cells 2
Autofilter in protected worksheets 0
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
HELP: Selecting Non-Visible (Hidden) Cells when AutoFilter is Appl 2
custom autofilter 3
Possible Autofilter Bug (2003 and 2007) 5

Top