| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Page set up for all tabs in workbook
A quick way to do this without code is to right click on the tab of the
sheet with the correct print format, click Select All Sheets, and then go to File - Page Setup and click OK. This will copy the print format (except repeating title lines) to all other pages in the group. Then right click on any tab in the group and click ungroup. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i link the names of tabs in a workbook to a summary page? | Excel Discussion (Misc queries) | |||
| *consecutive* page numbers across all tabs in workbook?? | Excel Discussion (Misc queries) | |||
| FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
| Page set up for a workbook, so each sheet gets the same format ? | Excel Worksheet Functions | |||
| Copy page format into an entire workbook | Excel Worksheet Functions | |||
![Johnny[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
