How to set a default template in Excel. VBA editor to confirm Excel's start up path. With Excel 2011 and Excel 2016 installed on the same Mac in May 2016,.
When we set up page settings for a worksheet, we can copy the page settings to other worksheets with the following steps: 1. Activate the worksheet with the page settings you want to copy. Then, hold down the Shift or Ctrl key to select multiple worksheets you want to copy the page settings to. Or you can right-click on one of the sheet tabs, and select the Select All Sheets from the menu, if you want to copy the page settings to all worksheets. See screenshot: 3.
And the worksheets you want to apply the specified page settings have been selected, then click Page Layout, and find the dialog box launcher to click it, see screenshot: 4. And a Page Setup dialog box will pop out, click OK directly. By doing so, you will copy all the basic page settings from the active worksheet to all the others in the current workbook. You can click File Print to preview the result. Copy page setup to other worksheets with Kutools for excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. After installing Kutools for Excel, please do as follows: 1. Active the worksheet that you want to apply its page settings for other worksheets.
Click Enterprise Printing Tools Copy Page Setup, see screenshot: 3. In the Copy Page Setup dialog box:. (1.) All worksheets within the current workbook are listed in the left list box, except the active worksheet which contains the page settings. Specify the worksheets that you want to apply the page setup settings. (2.) All page setup settings will be listed in the right pane, such as the page setup attributes, the margin attributes, the Header / Footer attributes and Sheet setup attributes. If there are some attributes of the current worksheet that you don't want to copy and apply to other worksheets, please unchecked them in the right pane. Then click OK to copy and apply the page settings to the checked worksheets.
And the worksheets will have the same page setups. You can click File Print to preview the result, see screenshot: For more information about the Copy Page Setup feature, please visit detailed description. Related articles. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful:.
Merge Cell/Rows/Columns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,.
More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.
It isn't clear why you're having to do this in 'every' workbook or what the 'issues' are:-) The 2 features you mention are actually one in the same - simply different methods of imposing scaling of the content. The Fit To option allows Excel to scale the content as necessary whereas the Scale value allows you to specify the preferred percentage yourself. Pursuant to that, Fit To adjusts Scale value but entering a Scale value does not activate (i.e., check the box for) Fit To settings. For example, I have a file which is too wide to fit on a single sheet of paper based on paper size & margin settings.
If I use Fit To for 1 page wide x 1 page tall Excel automatically sets the Scale value to 83%. If I clear the Fit To check Excel sets the Scaling value back to 100%.
IOW, Fit To is a convenience feature for Scaling the Print Area. Additionally, Scaling is worksheet specific. It is neither a workbook setting nor a global Excel preference. Each sheet in a book can have a different scaling percentage based on the volume of content in its Print Area & the needs for that particular sheet. Further, the values set are saved with the workbook file, so each time the file is opened each sheet's Layout specifications are as they last were, assuming the workbook was saved after the adjustments were made.
If you'll provide a more detailed description of the problem perhaps someone can offer some explanations & useful suggestions. Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J.