What does a blue row number means?

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

Guest

are they filtered using the autofilter?
Can you turn this off? (data > filter > autofilter)
 
G

Gord Dibben

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
 

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

Row numbers are blue 1
blue row numbers 3
Row Header Mystery 10
Some row numbers blue some black, why? 2
blue row numbers in excel 2
Unhide a row 1
Macro: Unhiding a row daily 1
What is blue triangle? 2

Top