| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Page Setup Across Multiple Worksheets
I have designed the page setup requirements for one worksheet (print area,
rows to repeat at top, columns to repeat, etc.). These are not the normal default settings. I want to copy these setting to other worksheets in the same workbook. I have tried the following: 1. Activate the sheet that contains the desired setup info. This is the "source" sheet. 2. Select the "target" sheets. Press Ctrl and click the sheet tabs of the sheets you want to update with the settings from the source sheet. 3. Select File, Page Setup and click OK. This doesn't seem to work. Any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy page settings to multiple worksheets in excel? | Setting up and Configuration of Excel | |||
| Sumif with multiple worksheets | Excel Worksheet Functions | |||
| Auto page numbering for several worksheets | Excel Worksheet Functions | |||
| How can I copy page setup settings to other worksheets? Thanks | Excel Discussion (Misc queries) | |||
| How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) | |||
Threaded Mode
