If you create a file named book.xlt and store it in your XLStart folder, then
excel will use this template file whenever you click on the new icon on the
standard toolbar.

You can also create a file named sheet.xlt that will be used as a template
whenever you insert a new worksheet into an existing workbook.

Just make sure you change the page orientation (and headers/footers and anything
else you want) in those template workbooks.

Ferds wrote:

When I go to print preview the page orintation is set to portrait although I
mostly require it to be in landscape

Is it possible to to change the default to do this

--

Dave Peterson