Sorting in excel without changing colors

Closed
TDKIII - Oct 3, 2009 at 12:31 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 5, 2009 at 12:08 PM
Hello,

I have a simple spreadsheet in which every other row has a background color and the others have none. When I sort the rows I want the spreadsheet to keep the background colors in place and just sort the text.

Is this possible? If so, how do I do it?

I have office 2000.

Thanks, TDKIII
Related:

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 5, 2009 at 12:08 PM
Hi

I hope the procedure given in the site https://www.contextures.com/xlcondformat03.html
for "Shade Alternating Rows" will solve your problem
-1