Copy formatted in several sheets of a workbook

E

Emece

I have a lot of formatted text in the first sheet of a workbook, in this same
workbook I have 17 sheets, and I need to copy the exact formatted text in the
rest of the sheets. Is there a way to do it all by once, instead of copying
it sheet by sheet? Also I want to specify the same page configuration page
for all sheets, is there a way to do this?

Thanks in advance.

Regards,
Emece.
 
R

Ray A

One way:
Assuming the formatted text is on sheet 1
Activate sheet 1>hold the shift key and click on sheet 18. You have now
grouped the sheets. Highlight the cells to copy then Edit>Fill>Across
worksheets>dialog box- all
Right click on any sheet name then Ungroup sheets.
HTH
 
Top