A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

margin defaluts



 
 
Thread Tools Display Modes
  #1  
Old August 9th, 2004, 06:35 PM
chrisg
external usenet poster
 
Posts: n/a
Default 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  
Old August 10th, 2004, 03:23 AM
Paul B
external usenet poster
 
Posts: n/a
Default 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  
Old August 10th, 2004, 01:37 PM
chrisg
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 07:09 AM.


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