Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I apply page settings to all sheets in Excel?
I would like to apply Page Setup settings (margins, header/footer, etc.) to
all sheets of an existing Excel file without going into each sheet. I know I can copy a sheet and the settings will be copied with it, but this is an existing file. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I apply page settings to all sheets in Excel?
Hi
Group the sheets you want to change. Change one of them and they all follow suite!! To group, click the first tab and then Shift-click the last tab. Andy. "Richard S" <Richard wrote in message ... I would like to apply Page Setup settings (margins, header/footer, etc.) to all sheets of an existing Excel file without going into each sheet. I know I can copy a sheet and the settings will be copied with it, but this is an existing file. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I apply page settings to all sheets in Excel?
I don't know about pasting the settings, but you can highlight multiple
worksheet tabs and then go to Page Setup, and the options you select will affect all of the highlighted sheets. "Richard S" wrote: I would like to apply Page Setup settings (margins, header/footer, etc.) to all sheets of an existing Excel file without going into each sheet. I know I can copy a sheet and the settings will be copied with it, but this is an existing file. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I apply page settings to all sheets in Excel?
Richard
Select one sheet then right-click and "Select all sheets" Do your page setrup on the active sheet and will done to all. Note: you cannot set a print range or rows/columns to repeat using this method. Gord Dibben MS Excel MVP On Mon, 23 Jan 2006 09:11:02 -0800, Richard S <Richard wrote: I would like to apply Page Setup settings (margins, header/footer, etc.) to all sheets of an existing Excel file without going into each sheet. I know I can copy a sheet and the settings will be copied with it, but this is an existing file. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I apply page settings to all sheets in Excel?
In article , <Andy wrote:
Hi Group the sheets you want to change. Change one of them and they all follow suite!! To group, click the first tab and then Shift-click the last tab. As an extra piece of advice, once you have finished, be sure to ungroup your sheets again. You can do a lot of damage in a short time if you don't :) "Richard S" <Richard wrote in message ... I would like to apply Page Setup settings (margins, header/footer, etc.) to all sheets of an existing Excel file without going into each sheet. I know I can copy a sheet and the settings will be copied with it, but this is an existing file. Bruce ---------------------------------------- I believe you find life such a problem because you think there are the good people and the bad people. You're wrong, of course. There are, always and only, the bad people, but some of them are on opposite sides. Lord Vetinari in Guards ! Guards ! - Terry Pratchett Caution ===== followups may have been changed to relevant groups (if there were any) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel ignores boot-time regional settings when interpreting a date | Excel Discussion (Misc queries) | |||
excel 2003 changing saved print settings | Excel Discussion (Misc queries) | |||
Varying page Excel report | Excel Discussion (Misc queries) | |||
changing page break in an excel file | New Users to Excel | |||
excel 2003 page numbering | Excel Worksheet Functions |