default margins

archana ahuja · Mar 20th, 2002, 05:53 AM

how do i set default margins for all my excel files / worksheets.

Sbirro Cornuto · Mar 20th, 2002, 06:11 AM

Quote:

On 2002-03-20 04:53, archana ahuja wrote:
how do i set default margins for all my excel files / worksheets.

Does this help you?

With ActiveSheet.PageSetup

.LeftMargin = Application.InchesToPoints(0.78740157480315)
.RightMargin = Application.InchesToPoints(0.78740157480315)
.TopMargin = Application.InchesToPoints(0.984251968503937)
.BottomMargin = Application.InchesToPoints(0.984251968503937)
.HeaderMargin = Application.InchesToPoints(0.511811023622047)
.FooterMargin = Application.InchesToPoints(0.511811023622047)

End With

paelinck · Mar 20th, 2002, 06:15 AM

You can also set the desired margins in an empty workbook and save it as a template with the name Book.xlt or Sheet.xlt in the XLStart folder in your Microsoft Excel program folder. Microsoft Excel uses these templates to create new default workbooks or to insert new worksheets when you click Worksheet on the Insert menu.

Marc

marnie · Apr 27th, 2002, 10:22 AM

Thanks this was really easy. I saved all kinds of print settings. It was bugging me how to avoid setting the print settings all the time. The only part I couldn't get to work was saving the workbook in the XLStart folder. I have one of those folders, but it's in the Office folder, I don't have a separate Excel folder. I looked it up on the help menu and it gave the exact instructions you gave. I'm not sure why my folders aren't consistent. What I ended up doing was creating a shortcut on my desktop to the BOOK.XLT, so now I'll always use that shortcut rather than the Excel shortcut. It works and is just as easy.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 05:53 AM	#1
archana ahuja New Member Join Date: Mar 2002 Posts: 1	how do i set default margins for all my excel files / worksheets.

Mar 20th, 2002, 06:15 AM	#3
paelinck Board Regular Join Date: Mar 2002 Location: Leiden, The Netherlands Posts: 68	You can also set the desired margins in an empty workbook and save it as a template with the name Book.xlt or Sheet.xlt in the XLStart folder in your Microsoft Excel program folder. Microsoft Excel uses these templates to create new default workbooks or to insert new worksheets when you click Worksheet on the Insert menu. Marc

Apr 27th, 2002, 10:22 AM	#4
marnie Board Regular Join Date: Apr 2002 Posts: 82	Thanks this was really easy. I saved all kinds of print settings. It was bugging me how to avoid setting the print settings all the time. The only part I couldn't get to work was saving the workbook in the XLStart folder. I have one of those folders, but it's in the Office folder, I don't have a separate Excel folder. I looked it up on the help menu and it gave the exact instructions you gave. I'm not sure why my folders aren't consistent. What I ended up doing was creating a shortcut on my desktop to the BOOK.XLT, so now I'll always use that shortcut rather than the Excel shortcut. It works and is just as easy.