why does excel for mac open full screen every time?

Why Does Excel Open Screen Every Time? Free PDF Make

Simply make the changes you want to persist in all new workbooks and then save the file appropriately as a template: Click the File tab and choose Save As.

When you buy through our links, TechRepublic may earn a commission.

Changing those settings every time you start a new workbook can be a blow to productivity if you do it often.

Instead, modify these settings so that each new workbook opens configured to your liking.

In this article, Ill share 10 default settings you might want to change.

Theres no downloadable demonstration file, and you cant make these changes in the browser edition.

Why Does Excel Open Screen Every Time? Free PDF Make

Note: This article is also available in the free PDF Make Office 2016 work your way by changing these default settings.

LEARN MORE: Office 365 Consumer pricing and features 1: Number of sheets Every workbook includes three sheets by default.

To change this setting: Click the File tab and then click Options.

In the When Creating New Workbooks section, enter the desired number in the Include This Many Sheets option ( Figure A ).

Click OK. Figure A Specify the number of sheets in new workbooks.

Starting workbook.

If youre using Windows 10, you can find the folder here: C:Users username AppDataRoamingMicrosoftExcelXLSTART If you cant find the folder, open Excel Visual Basic Editor (VBE) by pressing AltF11.

Then, enter the following command in the Immediate window and press Enter: application.StartupPath.

Figure B The Immediate window offers a quick way to find XLSTART.

If this is the case, launch Windows Explorer and click the Hidden option in the Showhide group on the View tab.

SEE: 30 things you should never do in Microsoft Office (free TechRepublic PDF) 3: Cursor movement Excel moves the cursor down one cell when you press Enter.

If most of your data input is from left to right, youll find this annoying.

You can press Tab instead of Enter, or you can adjust this behavior as follows: Click the File tab and then choose Options.

In the Editing Options section, choose Right from the Direction dropdown under the After Pressing Enter, Move Selection option ( Figure C ).

You can choose Right, Left, Up, or Down.

Click OK. Figure C Change the cursors movement behavior.

In the When Creating New Workbooks section, choose the appropriate font from the Use This As The Default Font dropdown.

To change the size, choose a setting from the Font Size dropdown ( Figure D ).

Figure D Update the font and font size for new workbooks.

Template modifications Like Word, Excel bases all new workbooks on a template.

Modifications you make to Book.xltm are present in all new workbooks.

Why Does Excel For Mac Open Full Screen Every Time?