on-a-mission wrote:
i have a worksheet with data in column A, every row is either grey or
white shading. i always want to keep the shading alterante grey/white

a1: 7 (white shading)
a2: 4 (grey shading)
a3: 3 (white shading)
a4: 5 (grey shading)
a5: 1 (white shading)
a6: 2 (grey shading)

when i sort assending it mucks up the shading becuase it moves the data
as well as the shaded cell.
is there any way of keeping the cells locked and just sort the data???


This doesn't really lock the shading but it makes it really easy to redo.
Look at a freebie program called ASAP Utilities

http://www.asap-utilities.com/

There's a selection that lets you color every nth row or column. Lots of
other useful tools included in the package.

gls858