MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by jerry broadway on December 28, 2001 8:52 PM

how do i change the default margin in excel 2000 or exceo 97 they should be the same

Posted by Jacob on December 28, 2001 9:08 PM


Sounds like you want to make your own template instead of using the default one. Here is the help file on what you need.

Create a sheet template for new worksheets
Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type.

On the File menu, click Save As.
Show Me

In the Save as type box, click Template (*.xlt).

In the Save in box, select the folder where you want to store the template.
To create the default worksheet template, select either the XLStart folder or the alternate startup folder. The XLStart folder is usually
C:\os\Profiles\user_name\Application Data\Microsoft\Excel\XLStart
where os is the operating system folder — for example, Windows.

To create a custom sheet template, select the Templates folder, which is usually
C:\os\Profiles\user_name\Application Data\Microsoft\Templates
where os is the operating system folder — for example, Windows.

In the File name box, type sheet to create a template for default worksheets.
To create a custom sheet template, type any valid file name.

Click Save, and then click Close on the File menu.

Hope this helps