Row numbers blues

[Onion]

Hi,
I used Data...Filter...Advanced Filter... Unique...(in
place) and the row numbering is now blue.
Can it be changed back to black?

Thanks

 

[Peo Sjoblom]

It's because it's filtered, do data>filter>show all,
if you want to keep the filtered list, select copy to another location instead


Regards,

Peo Sjoblom

 

[Gord Dibben]

Onion

Only if you go to Data>Filter>Show All.

You would be better off to copy the uniques to another area or another
worksheet.

See Debra Dalgleish's site for more info on this.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben Excel MVP