View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Gregory John Gregory is offline
external usenet poster
 
Posts: 22
Default How do I fix the background shading by position?

I wish to shade the background with alternating stripes of light-blue and
white for legibility of the data output (similar to the old computer
print-out paper).

I can cut and paste the format, but when I do a data sort, it takes to cell
shading along with it. Is there a way to create a fixed background that does
not move if I sort, insert, or delete cells?