Copy formatted in several sheets of a workbook
 

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.

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


"Emece" wrote:

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.