Select all the cells in the sheet by clicking in the Upper left hand corner.
Press the copy format tool (A little paintbrush icon)
Select the destination sheet tab
press the Upper left hand corner

Warning-----Will only work if the sheet layouts are the same.

"Marlene K." wrote:

I have several worksheets in a single workbook. I need to update the
formatting (such as header, show gridlines, landscape, margins, etc.) on all
the worksheets and I would like all the formatting to be the same. Is there
a way of copying the formatting from sheet 1 to sheet 2, 3, 4, 5 etc.?