In this post you'll discover how to save an Excel spreadsheet for the first time, then save further updates, close the file, re-open the file, create a brand new spreadsheet, create shortcuts to spreadsheets you use frequently, and other fundamental file skills like rename, delete, move, find or switch.
Beginners tour of the Excel screen
1. Click the File tab, then choose NEW on the sidebar.
A gallery of templates is displayed. When you have mastered the basics, you can come back and use one of these templates to create a new spreadsheet. You’ll find a lot of the hard work has already been done.
2. If you just want a blank workbook, choose the first thumbnail Blank Workbook.
3. The new workbook is created and given the default filename (Book1, Book2, Book3 etc.)
4. You can also press Ctrl N to bypass the dialog box and create a new blank workbook in one step.
To save an Excel spreadsheet for the very first time:
1. Click the File tab.
2. Choose Save or Save As on the left sidebar.
3. Click Browse.
4. Choose a folder to save your workbook in.
5. In the filename box, type a name for your workbook and click Save.
6. Once saved, you can quickly save any future changes by pressing Ctrl S.
If you have already saved the workbook, but you have since made some changes and want to save them:
1. Click the File tab.
2. Choose Save on the left sidebar. The existing filename is used, and the changes are saved.
3. To save a copy of the spreadsheet to a separate file:
4. Click the File tab.
5. Choose Save As on the left sidebar.
6. Click Browse.
7. Choose a folder to save your workbook in.
8. In the filename box, type a name for your new workbook and click Save.
All file management (opening, saving and closing a file) is accessed through the FILE tab, which is at the top-left of the screen.
To open an existing workbook:
1. Click the FILE tab.
2. Choose OPEN on the left sidebar.
3. Click BROWSE at the bottom of the middle panel.
4. Navigate to where your file is stored
5. Select your spreadsheet.
6. Click Open
Excel lists the most recent files you worked on to save you the hassle of searching for them.
To re-open a file you have worked on recently:
1. Click the File tab the click OPEN on the left sidebar.
2. Choose RECENT in the middle column.
3. On the right column. locate and double-left-click the file name to open it.
When you hover over a file in the RECENT list a horizontal pushpin symbol appears.
When you click the pushpin, it changes to a vertical pushpin which indicates that the file is now pinned.
In the RECENT files list, the most recent files are listed at the top and the oldest files are listed at the bottom. As you open different spreadsheets, older files get moved down the list and eventually drop off.
Pinned files are locked at the top of the list and never move. Pin current or commonly used files.
To rename an Excel spreadsheet:
1. Open File Explorer.
File Explorer has a yellow folder icon and used to be called Windows Explorer.
Also, it should not be confused with Internet Explorer, an internet browser that has also been renamed to Edge.
2. Navigate your folders and locate your file.
3. Right-click on the file name then click Rename on the context menu (or click twice slowly on the file name).
4. Type a new name and press Enter.
You can also use this technique when using File → Open or File → Save.
To delete a workbook, you no longer need:
1. Open File Explorer.
2. Navigate your folders and locate your file.
3. Right-click on the file name then click Delete on the context menu, or…
Click the file name once to select it, then press Delete on the keyboard.
If you cannot remember what you called the file or where you saved it, you can search for it.
1. Single-left-click the FILE tab then single-left-click OPEN.
2. In the top-right of the dialog is a search box. Single-left-click inside the search box.
3. Type the whole file name or part of the file name then press ENTER. The app will search for your file and display a list of matching results.
4. If you see your file listed, double-left-click it to open it.
Often you need to work on two or more workbooks at the same time. In the Windows task bar (at the very bottom of the screen), the Excel icon will show an overlap like the workbooks are stacked. This indicates that multiple workbooks are currently open.
To switch to a different workbook:
1. Hover over the stacked Excel icon on the task bar to display thumbnails for each open workbook.
2. Click the thumbnail of the workbook you want to switch to.
When you switch to a different workbook, all the other open workbooks remain open in the background. You haven’t lost them. You don’t need to save them first. You can switch workbooks any time.
