Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy formatting from 1 sheet to next in same workbook?
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.? |
#2
|
|||
|
|||
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.? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy a protected sheet without copying the protection? | Excel Discussion (Misc queries) | |||
How do I copy Page Setups from one Sheet to Another sheet? | Excel Worksheet Functions | |||
Copy sheet to new workbook | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Copy formula...sheet 2 sheet | New Users to Excel |