ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What does a blue row number means? (https://www.excelbanter.com/excel-discussion-misc-queries/94971-what-does-blue-row-number-means.html)

Turquoise_dax

What does a blue row number means?
 

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:


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=553711


Allllen

What does a blue row number means?
 
are they filtered using the autofilter?
Can you turn this off? (data filter autofilter)
--
Allllen


"Turquoise_dax" wrote:


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:


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=553711



Gord Dibben

What does a blue row number means?
 
The blue row numbers indicate you r rows are in filter mode.

Try DataFilter and turn off Autofilter or undo an Advanced Filter.


Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 11:33:54 -0500, Turquoise_dax
wrote:


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:




All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com