Start a new workbook.
Set up everything you want--headers/footers/layout...
Save it as book.xlt in your XLStart folder.

Then excel will use that when you create a new workbook by clicking on the new
icon on the standard toolbar.

If you want the same thing when you add a new worksheet to an existing workbook,
save another workbook (probably a single sheet???) in that same XLStart
folder--but name it Sheet.xlt.

Anne Ryan wrote:

I would like to change my page layout so that every time I open a new excel
sheet it is landscape form rather than portrait. Can this be done? how?

--

Dave Peterson