I'm creating the same worksheet template multiple times within the same workbook (each sheet will have different info entered), is there any way to hold the page margins, scaling and print range from the first worksheet? All my other formatting follows (formulas, fonts, cell width/height, etc.) but not the print formatting.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Copy Worksheets and Keep All Formatting - Including Print Formatting
0
Post Edited
Title: Title was not descriptive.
Answers
1
Selected Answer
The suggestion above from Variatus is the method commonly followed. However, if the pages have already been created, several changes made and rather difficult to start by copying the first page again,
> Note the scale you want > CTRL+click each worksheet tab > File menu > Page Setup > Enter desired scales > OK.
0
A copy you make of the first sheet would have all the formatting you want to preserve. The you select all (click on the little square in the top left corner where the vertical and horizontal rulers meet) and press the Delete button. That will remove all contents, leaving the formatting in place.