I want to create a new worksheet within my workbook which has all the formatting of an existing worksheet. How do I do that?
I want to create a new worksheet within my workbook which has all the formatting of an existing worksheet. How do I do that?
Right click on an existing worksheet and select "Move or Copy" -- check "Create a Copy" and click OK. Rename your new sheet and Clear Contents of cells if needed.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
DonkeyOte suggesttion is also my recommend method but this is to show another method also - It may help you learn some more functions of Excel
Select all cells (click on square to left of Column headers & above the row headers)
Copy
Goto a new book or sheet
Pastespecial > Format
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks