| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to applythe page setup setings to allsheets in afile in excel
iI want to apply the page setup settings to all sheets in an excel work book.
How can I do it without having to go to each sheet and then doing it individually? Cn any one help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to applythe page setup setings to allsheets in afile in excel
Asif -
One method: Right-click a worksheet tab (at the bottom of the display), and choose Select All Sheets. Then choose File | Page Setup ... and make any other format changes that you want to apply to all sheets. Finally, right-click a worksheet tab, and choose Ungroup Sheets. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Asif" wrote in message ... iI want to apply the page setup settings to all sheets in an excel work book. How can I do it without having to go to each sheet and then doing it individually? Cn any one help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
| setup my page size in Excel to A3? | Setting up and Configuration of Excel | |||
| Excel Page Setup | Excel Discussion (Misc queries) | |||
| Excel Printing and Page Setup | Excel Discussion (Misc queries) | |||
| Page setup in excel. | Setting up and Configuration of Excel | |||
Linear Mode
