View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dkingston
 
Posts: n/a
Default don't move formats on sort

i have a sheet where every other line is shaded. i want to sort the data but
maintain the every other line shaded format. is there a way to do this
without writing a macro to redo the formating every time i sort?
thanks in advance for your time.
dkingston