Click the File tab and then choose Options.

You can press Tab instead of Enter, or you can adjust this behavior as follows: If most of your data input is from left to right, you’ll find this annoying. SEE: 30 things you should never do in Microsoft Office (free TechRepublic PDF) 3: Cursor movementĮxcel moves the cursor down one cell when you press Enter. If this is the case, launch Windows Explorer and click the Hidden option in the Show/hide group on the View tab. Figure B The Immediate window offers a quick way to find XLSTART.ĭuring the save process, you might not see AppData. If the Immediate window isn’t open, press Ctrl+G. The VBE will display the correct path in the Immediate window, as shown in Figure B. Then, enter the following command in the Immediate window and press Enter: If you can’t find the folder, open Excel Visual Basic Editor (VBE) by pressing Alt+F11. If you’re using Windows 10, you can find the folder here:Ĭ:Users usernameAppDataRoamingMicrosoftExcelXLSTART Simply save the file in Excel’s XLSTART folder. If you often work with the same workbook, you can open it and launch Excel at the same time.

In the When Creating New Workbooks section, enter the desired number in the Include This Many Sheets option ( Figure A).įigure A Specify the number of sheets in new workbooks.

Click the File tab and then click Options.

You can add and delete sheets as needed, but you can also change the number initially provided. LEARN MORE: Office 365 Consumer pricing and features 1: Number of sheetsĮvery workbook includes three sheets by default. Note: This article is also available in the free PDF Make Office 2016 work your way by changing these default settings. There’s no downloadable demonstration file, and you can’t make these changes in the browser edition. I’m using Excel 2016 (desktop), but these options are customizable in earlier versions. How to create a fun Fly In effect in PowerPoint Get lifetime access to Microsoft Office 2021 for just $50 In this article, I’ll share 10 default settings you might want to change. Instead, modify these settings so that each new workbook opens configured to your liking.

Changing those settings every time you start a new workbook can be a blow to productivity if you do it often. Image: iStock/DragonImagesĮxcel, like Word, has an out-of-the-box environment that might not provide the most efficient setup for the way you work.

10 defaults you can change to make Excel 2016 work your wayīy changing a few settings, you can configure all new workbooks to automatically conform to the way you work.

Count by color excel 2016