You can also click Browse to find a location. You can save it to someone's SkyDrive (on the cloud) if you have this feature configured, other web locations, your computer, or you can add a place to save it.Ĭhoose the location on your computer where you want to save the file. Now you can choose where you want to save it. This setting can be changed to instead bypass this screen and create a blank workbook. In Excel 2013 and later, Excel defaults to showing the Start screen with recent workbooks, locations, and templates upon starting. To change the default number of worksheets in a new workbook, choose File > Options, pick the General category, and specify the desired number of sheets in the Include this many sheets setting. If I modify the location of User templates in the interface of Word and try to create a new default theme in PowerPoint, it ends up in a subfolder under the User Templates location of Word. The default is number of worksheets is 1 in Excel 2013 and earlier, the default is 3. You must also specify the format that you want to save the file in.Ĭlick File, then choose Save As on the left. Automatically start Excel with a blank workbook. It seems that the location of the theme files depends on the location of Words normal.dotm. First of all, when you click Save As, you must specify a file name. If you want to save the file to a new location, you must choose Save As.Ĭlicking Save As gives you a lot more options to saving your work. When you click Save, if another file of the same name exists, MS Excel will prompt you to either enter a new file name, or to replace the existing copy with the new version you are currently saving. Keep in mind that if this is a new workbook, it will save the file by the default name of Book1. Click File, then choose either Save or Save As on the left.Ĭlicking Save will enable you to save the file under its current name, and keep it saved at its current location. And now, whenever you click File > New in Excel 2013, the Personal tab is there and your custom Excel templates are available for use. You can do this quickly and easily in MS Excel 2013. In Microsoft Excel, go to File > Options > Save and paste the copied path into the Default personal templates location box, exactly as we did in step 2 of Method 1. Let's say that you've created a new workbook and wish to save it to your computer to use again later.