Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.word.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
page setup won't allow entering "rows to repeat at top" | Excel Discussion (Misc queries) | |||
set Print Preview to "preview" page that was being worked on? | Excel Discussion (Misc queries) | |||
Copy "Page Setup" for multiple worksheets of identical size. | Excel Discussion (Misc queries) | |||
No "Sheet" tab exists on Page Layout. Need to print gridlines.??? | Excel Worksheet Functions | |||
"Rows to repeat at top" option under page setup | Excel Worksheet Functions |