how do i permanently change the page setup in excel?

M

mahinawai

I would like to permanently save page margins, orientation, and gridline
selections so every time I open a new excel worksheet, it will be formatted
for optimal printing. thanks.
 
D

Dave Peterson

You could create a workbook template named book.xlt and store it in your XLStart
folder. You can name the sheets whatever you want (and do other stuff, too --
print headers/footers/margins).

In xl2003, a new workbook will be created based on this workbook when you click
on the New Icon on the standard toolbar.

And if you want this same info on each new sheet you add to an existing
workbook, create another template and store it in that same XLStart folder. But
name it Sheet.xlt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top