Excel Template Defaults Change

P

Patti Larsen

When I open excel - I would like it to open with Page Set Up defaults that I
define.

Can someone assist me with this.
 
D

Dave Peterson

You could set up a new workbook with all the settings you like.

Then save this as Book.xlt in your XLStart folder. Then every workbook that is
based on this template will inherit its settings.

You can set up another workbook named Sheet.xlt (also in XLStart). A worksheet
added to any existing workbook will inherit its settings.

(My book.xlt workbook only has one sheet. If you like multiple sheets, make
sure you set up each the way you like.)
 

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