If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
margin defaluts
Is there a way to change the default margins permanently? I would like to
have my margins @ 0.25" instead of 0.75" Thanks |
#2
|
|||
|
|||
margin defaluts
Set up a workbook as you want it (margins, number of sheets, cell formats,
headers, footers, gridlines to print, etc). Now Save As, and change the file type to "Excel Template (.xlt)" not (.xls). Locate your XLStart folder, typically somewhere like "C:\Program Files\Microsoft Office\Office\XLStart\", and save the file as book. Excel will add the .xlt for you Every time you open a new workbook from now on (you may have to restart Excel first) this template will be used. To revert back to the original, just delete this file. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "chrisg" wrote in message ... Is there a way to change the default margins permanently? I would like to have my margins @ 0.25" instead of 0.75" Thanks |
#3
|
|||
|
|||
margin defaluts
Thanks!! That worked perfectly!
"Paul B" wrote: Set up a workbook as you want it (margins, number of sheets, cell formats, headers, footers, gridlines to print, etc). Now Save As, and change the file type to "Excel Template (.xlt)" not (.xls). Locate your XLStart folder, typically somewhere like "C:\Program Files\Microsoft Office\Office\XLStart\", and save the file as book. Excel will add the .xlt for you Every time you open a new workbook from now on (you may have to restart Excel first) this template will be used. To revert back to the original, just delete this file. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "chrisg" wrote in message ... Is there a way to change the default margins permanently? I would like to have my margins @ 0.25" instead of 0.75" Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
text in the margin | CB | General Discussion | 4 | July 31st, 2004 04:52 PM |
Labels print w/o top margin | Dan Morgan | General Discussion | 2 | July 30th, 2004 11:45 PM |
What would cause a 2" right margin when it was not set? | jim | Page Layout | 5 | June 15th, 2004 01:33 PM |