View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jbclem[_3_] jbclem[_3_] is offline
external usenet poster
 
Posts: 5
Default making a copy/duplicate spreadsheet but row colors have changed

I'm trying to learn how to sort a spreadsheet (stock market data) by
individual columns (ie: dividends, EPS, etc...). As I first step I made a
copy of the spreadsheet and pasted it into a new spreadsheet.

The original one had different colored rows...first two rows white, next
three rows gray, next two rows white, next three rows gray, and so on. But
the copy I made has different row colors and some are too dark to read.

How can I make the copy or duplicate spreadsheet with the same original
colors?

John