

If you have several worksheets in the Workbook Template file, you may have to set the zoom for each sheet. Note: Keep in mind that I have set Excel preferences to have my workbooks open with just one worksheet. Make sure you save it to the startup location (discussed above).Click the Format: drop-down button and choose Excel Template (.xltx).Choose View > Zoom, then select 125% and click OK.This is where a modified template file should go.Ĭhange the Default Workbook in Excel 2011 Just to go Excel > Preferences then select General and click the Select… box for At startup, open all files in. Or you can check to see where the Excel startup files are located on your computer. Macintosh HD:Users: username:Library:Application Support:Microsoft:Office:User Templates:My Templates: It involves saving a template to a buried location, then manipulating the file in Finder to remove the extension. I want to have Excel 2011 (for Mac) open to a blank worksheet that is zoomed to 125% and it has taken a very long time to figure this out.
