View Single Post
  #1   Report Post  
san jose native
 
Posts: n/a
Default How do I copy formatting in a cell reference

I have a spreadsheet with 13 worksheets. On the first worksheet ("summary")
I have a cell (A1) that contains the year, "2005", in 24point red font. I
would like to reference it in each of the other 12 worksheets as
"=summary!a1" and have this copy the value, "2005", and the formatting. Is
this possible? Thank you.