Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 15
Default Are the "page setup" layout settings overwritten by page preview adjustments ?

I setup a page layout in menu

File-page setup.

As far as I know these settings are stored in the document itself.

Now I call menu

File-page preview

and click on the preview window the button "setup..."

If I change now these settings (again): Are these changes temporary or
are they saved permanently in the document resp. are the old settings
overwritten?

Jeff

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Are the "page setup" layout settings overwritten by page previewadjustments ?

Yes, they are changed. Click on the Margins button in Print Preview
and then widen one of the columns. When you click close and return to
the normal view you will see that the column has been widened in the
sheet, so csome of the changes can affect the sheet as well.

One thing you can't adjust in Print Preview is the print area, or
indeed anything on the Sheet tab of Print Setup.

Hope this helps.

Pete

On Mar 5, 7:41*pm, (Jeff Korn) wrote:
I setup a page layout in menu

File-page setup.

As far as I know these settings are stored in the document itself.

Now I call menu

File-page preview

and click on the preview window the button "setup..."

If I change now these settings (again): Are these changes temporary or
are they saved permanently in the document resp. are the old settings
overwritten?

Jeff


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Are the "page setup" layout settings overwritten by page preview adjustments ?

In File Page Layout, if you change the margin and exit the dialog, when you
save the document, the changes are saved with the document.

If you change the margin and press DEFAULT in the dialog, then the changes
are written to the template and will affect all new document based on the
template as well as the document.

--
Terry Farrell - MSWord MVP

"Jeff Korn" wrote in message
...
I setup a page layout in menu

File-page setup.

As far as I know these settings are stored in the document itself.

Now I call menu

File-page preview

and click on the preview window the button "setup..."

If I change now these settings (again): Are these changes temporary or
are they saved permanently in the document resp. are the old settings
overwritten?

Jeff


  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 54
Default Are the "page setup" layout settings overwritten by page preview a

As far as I know page setup settings are saved within the excel file

"Jeff Korn" wrote:

I setup a page layout in menu

File-page setup.

As far as I know these settings are stored in the document itself.

Now I call menu

File-page preview

and click on the preview window the button "setup..."

If I change now these settings (again): Are these changes temporary or
are they saved permanently in the document resp. are the old settings
overwritten?

Jeff


  #5   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 2
Default Are the "page setup" layout settings overwritten by page preview a

I Couldn't find the default button as suggested by Terry, perhaps this is
because I'm using excel 2003. If you are using 2003 You can create a default
template which will store your preferred settings for all future documents.

Open a blank workbook, make your changes to settings as required (e.g., page
size, margins, etc.) and save the workbook as a workbook template (book.xlt)
into the XLSTART directory, usually c:\program files\microsoft office\office
11\xlstart
(You will need to exit excel and start it again in order for the changes to
be picked up). Any new workbooks you create will pick up the settings saved
in this template.



"Jeff Korn" wrote:

I setup a page layout in menu

File-page setup.

As far as I know these settings are stored in the document itself.

Now I call menu

File-page preview

and click on the preview window the button "setup..."

If I change now these settings (again): Are these changes temporary or
are they saved permanently in the document resp. are the old settings
overwritten?

Jeff




  #6   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 12
Default Are the "page setup" layout settings overwritten by page preview a

This is a Word newsgroup, so the for a definitive answer to your question,
post it in the Excel newsgroup.

Terry

"qweqweewq" wrote in message
...
I Couldn't find the default button as suggested by Terry, perhaps this is
because I'm using excel 2003. If you are using 2003 You can create a
default
template which will store your preferred settings for all future
documents.

Open a blank workbook, make your changes to settings as required (e.g.,
page
size, margins, etc.) and save the workbook as a workbook template
(book.xlt)
into the XLSTART directory, usually c:\program files\microsoft
office\office
11\xlstart
(You will need to exit excel and start it again in order for the changes
to
be picked up). Any new workbooks you create will pick up the settings
saved
in this template.



"Jeff Korn" wrote:

I setup a page layout in menu

File-page setup.

As far as I know these settings are stored in the document itself.

Now I call menu

File-page preview

and click on the preview window the button "setup..."

If I change now these settings (again): Are these changes temporary or
are they saved permanently in the document resp. are the old settings
overwritten?

Jeff



  #7   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 2,819
Default Are the "page setup" layout settings overwritten by page previewa

Hi Terry,

You replied to a message that is cross-posted to two Excel groups.

Terry Farrell wrote:
This is a Word newsgroup, so the for a definitive answer to your
question, post it in the Excel newsgroup.

Terry

"qweqweewq" wrote in message
...

I Couldn't find the default button as suggested by Terry, perhaps this is
because I'm using excel 2003. If you are using 2003 You can create a
default
template which will store your preferred settings for all future
documents.

Open a blank workbook, make your changes to settings as required
(e.g., page
size, margins, etc.) and save the workbook as a workbook template
(book.xlt)
into the XLSTART directory, usually c:\program files\microsoft
office\office
11\xlstart
(You will need to exit excel and start it again in order for the
changes to
be picked up). Any new workbooks you create will pick up the settings
saved
in this template.



"Jeff Korn" wrote:

I setup a page layout in menu

File-page setup.

As far as I know these settings are stored in the document itself.

Now I call menu

File-page preview

and click on the preview window the button "setup..."

If I change now these settings (again): Are these changes temporary or
are they saved permanently in the document resp. are the old settings
overwritten?

Jeff




  #8   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 12
Default Are the "page setup" layout settings overwritten by page preview a

Pardon me. I missed that.

Terry

"Bob I" wrote in message
...
Hi Terry,

You replied to a message that is cross-posted to two Excel groups.

Terry Farrell wrote:
This is a Word newsgroup, so the for a definitive answer to your
question, post it in the Excel newsgroup.

Terry


  #9   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
external usenet poster
 
Posts: 2,819
Default Are the "page setup" layout settings overwritten by page previewa

No problem.

Terry Farrell wrote:

Pardon me. I missed that.

Terry

"Bob I" wrote in message
...

Hi Terry,

You replied to a message that is cross-posted to two Excel groups.

Terry Farrell wrote:

This is a Word newsgroup, so the for a definitive answer to your
question, post it in the Excel newsgroup.

Terry



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
page setup won't allow entering "rows to repeat at top" jasbrow Excel Discussion (Misc queries) 1 February 11th 08 09:34 PM
set Print Preview to "preview" page that was being worked on? ACULAK Excel Discussion (Misc queries) 0 October 5th 07 02:06 AM
Copy "Page Setup" for multiple worksheets of identical size. BrotherBax Excel Discussion (Misc queries) 1 August 30th 07 04:12 PM
No "Sheet" tab exists on Page Layout. Need to print gridlines.??? Terre Excel Worksheet Functions 4 September 20th 06 02:04 AM
"Rows to repeat at top" option under page setup PaulandArt Excel Worksheet Functions 1 November 7th 05 03:13 PM


All times are GMT +1. The time now is 06:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"