software

I am using excel 2003 and I am wanting to save the page setup settings (ie,
margins, heading, landscape orientation) to transfer to other pages within
the workbook.

Select your quot;masterquot; worksheet.
control click on the other worksheets that should have the same page setup.
file|page setup|click ok

rightclick on one of the grouped worksheet tabs and select Ungroup Sheets.

Lots of the page layout stuff can be changed using this technique.

bassett76 wrote:
gt;
gt; I am using excel 2003 and I am wanting to save the page setup settings (ie,
gt; margins, heading, landscape orientation) to transfer to other pages within
gt; the workbook.

--

Dave Peterson

to: Dave Peterson

please clarify your instructions ...
1) which is the quot;masterquot; worksheet
2) for quot;control clickquot; do you mean CTRL left/right click with mouse?
3) what's a quot;grouped worksheet?quot;, when I right clicked on it the menu did
not give me the option Ungroup Sheets.

How can I permanently save the settings so they are not lost when I exit the
file?

quot;Dave Petersonquot; wrote:

gt; Select your quot;masterquot; worksheet.
gt; control click on the other worksheets that should have the same page setup.
gt; file|page setup|click ok
gt;
gt; rightclick on one of the grouped worksheet tabs and select Ungroup Sheets.
gt;
gt; Lots of the page layout stuff can be changed using this technique.
gt;
gt; bassett76 wrote:
gt; gt;
gt; gt; I am using excel 2003 and I am wanting to save the page setup settings (ie,
gt; gt; margins, heading, landscape orientation) to transfer to other pages within
gt; gt; the workbook.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

The master sheet is the worksheet that has the correct settings/headers/footers.

Ctrl-click would mean control-primary click. For most people, that's the left
button--but it is changeable if you're kind of weird!

If you select more than one sheet, you've grouped them. Check the titlebar at
the top and you'll see [Group]. This means more than one sheet is selected.

Save your workbook and any changes you've done should be saved.

DR support wrote:
gt;
gt; to: Dave Peterson
gt;
gt; please clarify your instructions ...
gt; 1) which is the quot;masterquot; worksheet
gt; 2) for quot;control clickquot; do you mean CTRL left/right click with mouse?
gt; 3) what's a quot;grouped worksheet?quot;, when I right clicked on it the menu did
gt; not give me the option Ungroup Sheets.
gt;
gt; How can I permanently save the settings so they are not lost when I exit the
gt; file?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Select your quot;masterquot; worksheet.
gt; gt; control click on the other worksheets that should have the same page setup.
gt; gt; file|page setup|click ok
gt; gt;
gt; gt; rightclick on one of the grouped worksheet tabs and select Ungroup Sheets.
gt; gt;
gt; gt; Lots of the page layout stuff can be changed using this technique.
gt; gt;
gt; gt; bassett76 wrote:
gt; gt; gt;
gt; gt; gt; I am using excel 2003 and I am wanting to save the page setup settings (ie,
gt; gt; gt; margins, heading, landscape orientation) to transfer to other pages within
gt; gt; gt; the workbook.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

I want to save my page setup settings so they remain after I exit the file.

quot;Dave Petersonquot; wrote:

gt; The master sheet is the worksheet that has the correct settings/headers/footers.
gt;
gt; Ctrl-click would mean control-primary click. For most people, that's the left
gt; button--but it is changeable if you're kind of weird!
gt;
gt; If you select more than one sheet, you've grouped them. Check the titlebar at
gt; the top and you'll see [Group]. This means more than one sheet is selected.
gt;
gt; Save your workbook and any changes you've done should be saved.
gt;
gt; DR support wrote:
gt; gt;
gt; gt; to: Dave Peterson
gt; gt;
gt; gt; please clarify your instructions ...
gt; gt; 1) which is the quot;masterquot; worksheet
gt; gt; 2) for quot;control clickquot; do you mean CTRL left/right click with mouse?
gt; gt; 3) what's a quot;grouped worksheet?quot;, when I right clicked on it the menu did
gt; gt; not give me the option Ungroup Sheets.
gt; gt;
gt; gt; How can I permanently save the settings so they are not lost when I exit the
gt; gt; file?
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Select your quot;masterquot; worksheet.
gt; gt; gt; control click on the other worksheets that should have the same page setup.
gt; gt; gt; file|page setup|click ok
gt; gt; gt;
gt; gt; gt; rightclick on one of the grouped worksheet tabs and select Ungroup Sheets.
gt; gt; gt;
gt; gt; gt; Lots of the page layout stuff can be changed using this technique.
gt; gt; gt;
gt; gt; gt; bassett76 wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I am using excel 2003 and I am wanting to save the page setup settings (ie,
gt; gt; gt; gt; margins, heading, landscape orientation) to transfer to other pages within
gt; gt; gt; gt; the workbook.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

gt; gt; Save your workbook and any changes you've done should be saved.

DR support wrote:
gt;
gt; I want to save my page setup settings so they remain after I exit the file.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; The master sheet is the worksheet that has the correct settings/headers/footers.
gt; gt;
gt; gt; Ctrl-click would mean control-primary click. For most people, that's the left
gt; gt; button--but it is changeable if you're kind of weird!
gt; gt;
gt; gt; If you select more than one sheet, you've grouped them. Check the titlebar at
gt; gt; the top and you'll see [Group]. This means more than one sheet is selected.
gt; gt;
gt; gt; Save your workbook and any changes you've done should be saved.
gt; gt;
gt; gt; DR support wrote:
gt; gt; gt;
gt; gt; gt; to: Dave Peterson
gt; gt; gt;
gt; gt; gt; please clarify your instructions ...
gt; gt; gt; 1) which is the quot;masterquot; worksheet
gt; gt; gt; 2) for quot;control clickquot; do you mean CTRL left/right click with mouse?
gt; gt; gt; 3) what's a quot;grouped worksheet?quot;, when I right clicked on it the menu did
gt; gt; gt; not give me the option Ungroup Sheets.
gt; gt; gt;
gt; gt; gt; How can I permanently save the settings so they are not lost when I exit the
gt; gt; gt; file?
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Select your quot;masterquot; worksheet.
gt; gt; gt; gt; control click on the other worksheets that should have the same page setup.
gt; gt; gt; gt; file|page setup|click ok
gt; gt; gt; gt;
gt; gt; gt; gt; rightclick on one of the grouped worksheet tabs and select Ungroup Sheets.
gt; gt; gt; gt;
gt; gt; gt; gt; Lots of the page layout stuff can be changed using this technique.
gt; gt; gt; gt;
gt; gt; gt; gt; bassett76 wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I am using excel 2003 and I am wanting to save the page setup settings (ie,
gt; gt; gt; gt; gt; margins, heading, landscape orientation) to transfer to other pages within
gt; gt; gt; gt; gt; the workbook.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson