Is it possible to set margin defaults in Excel? Margins are automatically top and bottom 1", left and right .75". Is it possible to change these to a custom default so they do not have to be changed each time a new workbook is created?
Is it possible to set margin defaults in Excel? Margins are automatically top and bottom 1", left and right .75". Is it possible to change these to a custom default so they do not have to be changed each time a new workbook is created?
Hi
Yes, open a new workbook, set your margins footer, header..etc....then goto file/Save As, in the Save As Type window select templates and save it in your xlstart folder under the name of Book.xlt (you should find the folder in C:/Windows/Application Data/Microsoft/Excel).
Regards
JG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks