If you want to restore your workbook to that version, click the Restore button in the message bar at the top of your workbook.Īs stated earlier in this lesson, each new workbook that you open in Excel 2016 has one worksheet created for you by default. You can add worksheets to a workbook. You can also delete sheets from a workbook.īy default, the first worksheet contained within a notebook is named "Sheet1". You will see the older versions of the workbook in the History pane.Ĭlick a version to view it in a separate window. To view the historical versions of your workbook, go to the File tab and click History on the left. If you have SharePoint or OneDrive for Business, Excel 2016 saves versions of your workbooks files as you have them open and are working on them. 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.
#Excel 2016 recent files location Pc#
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.