Some row numbers blue some black, why?

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Some of the row numbers down the left side of my worksheet are blue and some
are black. What does this mean?
 
Hi,

The numbers turn blue when part of a autofiltered range. Remove the filter
and they will revert to black.

Mike
 
If you scroll to the top of your data, do you have drop down arrows on each
of your columns? On the data tab, is the "Filter" selected?
 

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

worksheets in one file listed in both blue and black, why? 3
Windows 10 shutdown black screen 13
Row numbers are blue 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Excel Conditional Formatting 1
Trouble identifying filtered column 1
how do I keep rows' formats when copying a formula? 2
What's in the adjacent cell? 5

Back
Top