MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to create standard excel format

Posted by Mong on November 18, 2001 9:04 PM

I would like to know that it is possible to create a standard format on header and footer for each new excel file. Every time you print the format is out to be the same.


Posted by Richard S on November 18, 2001 9:37 PM


In help, look under templates. You can create a file with the Header, Footer, fonts etc that you want all the time, and save it as Book.xlt (Save as Template). The location you save it to varies, but on my computer it's in c:\Documents and Settings\username\Templates. In the help file, it refers to OS etc, that's why I say the location varies. Yoou may have to fiddle with where you save the XLT file to.