Interested in learning more? Why not take an online Excel 2021 course? In the Save as Type field, choose the format in which you want to save the workbook. You can also click Browse to find a location. We're going to choose Desktop.Įnter a name for the file in the File Name text field, as pictured below. In the 'Save As' column, choose where you want to save the workbook. You can save it to your OneDrive, which is your cloud storage. In addition, you can save it to other web locations, This PC – which is your computer - or you can add a location by clicking 'Add a Place'.Ĭhoose the location on your computer where you want to save the file. This is an acceptable and much-used format that should be satisfactory for most Excel users, but you can select the format that you need depending on the work you need to save. Let's show you what we mean.Ĭlick File, then choose Save As on the left. Clicking Save As gives you a lot more options to saving your work. First of all, when you click Save As, you must specify a file name. You must also specify the format that you want to save the file in.Clicking Save will enable you to save the file under its current name and keep it saved at its current location. Keep in mind that if this is a new workbook, it will save the file by the default name of Book1. When you click Save, if another file of the same name exists, 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. If you want to save the file to a new location, you must choose Save As.You can do this quickly and easily in Excel 2016. Click File, then choose either Save or Save As on the left in the Backstage area. Let's say that you've created a new workbook and wish to save it on your computer. After all, saving your workbooks is the only way to insure that you won't lose any of your data – and that you can come back to work on it again later.

It can be argued that the most important thing you need to learn to do in Excel 2016 is to save your workbooks.

Excel 2016 recent files location