How do I copy formatting from 1 sheet to next in same workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I apply formatting from one worksheet to a whole workbook? 5
All sheets in workbook have same rows to repeat at top 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Relative worksheet reference for multiple worksheets in a workbook 5
formatting sheets in a workbook 4
Grouped sheets page formatting will copy the header 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How do I merge/combine different workbooks with different sheets 2

Back
Top