sort

[BWR]

Hello, how can i sort a huge list of lines in a worksheet without changing
the cell shading in the background? I have entered several lines of info and
staggered the shading in the cell lines (gray, then white, then gray, etc) to
make the worksheet easier to follow lines. Each time I sort the data in the
worksheet it takes the cell shading with it. I want to leave the cell
shading in the background and sort only the data.

 

[Max]

Tinkered with it in this manner, seems to work ok:
Make a copy of your original sheet, with the desired formatting*
Sort the original. Go back to the copy, select the range/entire sheet, copy
the formatting (click the Format Painter icon, the brush). Then go back to
the original, "paint" to restore the formatting.
*Formatting is assumed non CF
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik

 

[Bernie Deitrick]

Format all the cells white, then use Conditional formatting with the
"Formula is" condition with the formula

=MOD(ROW(),2)=0

and set the color to gray.

HTH,
Bernie
MS Excel MVP