| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Setup
I have an excel file with many workbooks (sheets? Tabs. not sure of precise
nomenclature) that I view in read-only mode. I need to print it. Is there a way to apply one page setup (page orientation, fit to, header/footer, margins) to all sheets/books (Tabs)? There are 10, and I really don't want to go through this for each. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page Setup
First off you need to group the sheets together. Hold down the control key
and select the sheets that you want to format (you can also use the shift key). Once you have selected all of the sheets then select File- Page Setup and make your changes. -- HTH... Jim Thomlinson "azutjw" wrote: I have an excel file with many workbooks (sheets? Tabs. not sure of precise nomenclature) that I view in read-only mode. I need to print it. Is there a way to apply one page setup (page orientation, fit to, header/footer, margins) to all sheets/books (Tabs)? There are 10, and I really don't want to go through this for each. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page Setup
Works good!! Many thanks!jw
"Jim Thomlinson" wrote: First off you need to group the sheets together. Hold down the control key and select the sheets that you want to format (you can also use the shift key). Once you have selected all of the sheets then select File- Page Setup and make your changes. -- HTH... Jim Thomlinson "azutjw" wrote: I have an excel file with many workbooks (sheets? Tabs. not sure of precise nomenclature) that I view in read-only mode. I need to print it. Is there a way to apply one page setup (page orientation, fit to, header/footer, margins) to all sheets/books (Tabs)? There are 10, and I really don't want to go through this for each. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are the "page setup" layout settings overwritten by page preview adjustments ? | Excel Discussion (Misc queries) | |||
| HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
| Page Setup | Excel Discussion (Misc queries) | |||
| Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) | |||
| Page Setup | Setting up and Configuration of Excel | |||
Linear Mode
