excel for mac 2016 do not allow a workbook to autofill format when other open it

Excel 2016 Do Not Allow A Workbook To Autofill Format When Other Open It 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.

Excel 2016 Do Not Allow A Workbook To Autofill Format When Other Open It Free PDF Make

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

You can add and delete sheets as needed, but you can also change the number initially provided.

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.

Font and font size Most of us dont need to change Excels default font and font size, but you certainly can.

If your organization has a certain formatting requirement, changing this default will save you a lot of time: Click the File tab and choose Options.

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.

Excel For Mac 2016 Do Not Allow A Workbook To Autofill Format When Other Open It