What does a blue row number means?

  • Thread starter Thread starter Turquoise_dax
  • Start date Start date
T

Turquoise_dax

I have a problem: I can't show some rows after they've been hidden with
a macro. I tryed the "select all / unhide", but it doesn't work.

I noticed the row numbers are all blue now. What does it mean? (This
could be the answer..:P):confused:
 
are they filtered using the autofilter?
Can you turn this off? (data > filter > autofilter)
 
The blue row numbers indicate you r rows are in filter mode.

Try Data>Filter and turn off Autofilter or undo an Advanced Filter.


Gord Dibben MS Excel MVP
 
Back
Top