View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default copy cell and formating

I am copying information from on sheet to another in the same workbook. Is
there a way to copy the entire format of the cell automatically?

Page 1
A B C
1
2 3<~~ number is red and bolded
3

Page 2
A B C
1
2 +page1!B2 <~~gives me a black non bolded 3
3

I want page to to have a red bolded 3. Is there a way? Any help would be
nice thank you .......

Eric