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

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


Regards,

Peo Sjoblom

"Onion" wrote:

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

Onion

Only if you go to DataFilterShow 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

On Thu, 13 Jan 2005 12:57:02 -0800, "Onion"
wrote:

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