How set or predefine the margins ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everybody
I need some help with this
I know to in word I edit the normal.dot change some options and save this file and the next time that i run the wor
I have the options saved in this file, example, fonts, colors, font size
I want to do this in a excel, I want to set the print area, margins and this options use forever because in this moment i change this options manually, I want to save this options for all books
My version is Excel XP sp2 Spanish
My so is Windows 2000 Sp4 Spanis
Thanks for all

Regards
Roque.
 
Roque said:
Hello everybody!
I need some help with this.
I know to in word I edit the normal.dot change some options and save this
Click to expand...
file and the next time that i run the word
I have the options saved in this file, example, fonts, colors, font size.
I want to do this in a excel, I want to set the print area, margins and
Click to expand...
this options use forever because in this moment i change this options
manually, I want to save this options for all books.
My version is Excel XP sp2 Spanish
My so is Windows 2000 Sp4 Spanish
Thanks for all.

Regards,
Roque.
Click to expand...

You need to save a template "Book.xlt" with your settings, and this will be
used for all new workbooks.
Similarly, you also need to save "Sheet.xlt" as this will be used for all
new worksheets that you require.
These should both be saved in your Xlstart folder.
Details are in Help under "templates, customizing workbook defaults". I'm
sorry, but I cannot help with the equivalent Spanish names.
 
Back
Top