Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets

Today, we continue to share with you how to create and open spreadsheets available in Excel 2016.

In the previous section in Excel 2016, TipsMake.com helped you get acquainted with Microsoft Excel and learn about OneDrive. Today, we continue to share with you how to create and open spreadsheets available in Excel 2016 . Invite you to consult!

Introducing Excel 2016 spreadsheet

Excel files are called Workbook files in Excel. Whenever you need to start a new project in Excel, you will need to create a new workbook file. There are several ways to start working with an Excel workbook. You can choose to create a new spreadsheet - either a blank spreadsheet or a pre- designed sample workbook - or open an existing spreadsheet .

Check out the video below to learn more about creating and opening available spreadsheets in Excel 2016 :

About OneDrive

Whenever you open or save a spreadsheet, you will have the option to use OneDrive , which is an online file storage service available in your Microsoft account. To enable this option, you will have to log into Office . To learn more, visit the Excel 2016 Complete Guide (Part 2): Learn about our OneDrive.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 1

Create a new blank Excel 2016 worksheet

1. Select the File tab. The Backstage view will appear.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 2

2. Select New , and then click Blank workbook .

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 3

3. A new blank worksheet will appear.

Open the existing Excel spreadsheet

In addition to creating new spreadsheets, you also need to open a previously saved spreadsheet. To learn more about saving spreadsheets, refer to the article The Excel 2016 Complete Guide (Part 4): How to store and share our spreadsheets.

1. Navigate to the Backstage view , then click Open .

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 4

2. Select Computer , then click Browse . Alternatively, you can choose OneDrive to open files stored on your OneDrive.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 5

3. The Open dialog box will appear. Locate the folder and select the spreadsheet, then click Open .

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 6

  1. If you recently opened the desired spreadsheet, you can browse recent spreadsheets instead of searching for files.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 7

Pin the Excel spreadsheet

If you regularly work with the same spreadsheet, you can pin it to the Backstage view mode for faster access.

1. Navigate to the Backstage view , then click Open . Your recently edited spreadsheets will appear.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 8

2. Hover over the spreadsheet you want to pin. The pin icon will appear next to the spreadsheet. Click the pin icon ( as shown ).

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 9

3. The workbook will be in Recent Workbooks . To unpin the spreadsheet, simply click the pin icon again.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 10

Use the template

Templates are pre- designed spreadsheets that you can use to create a new spreadsheet quickly. Templates often include custom formats and predefined formulas, so they can save you a lot of time and effort when starting a new project.

Create a new spreadsheet from the template

1. Click the File tab to access the Backstage view .

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 11

2. Select New . Some templates will appear below the Blank workbook option.

3. Choose a sample to review.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 12

4. The sample preview will appear with additional information on how to use the template.

5. Click Create to use the selected template.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 13

6. A new workbook will appear with the selected template.

  1. You can also browse templates by category or use the search bar to find a specific template.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 14

  1. It is important to note that not all templates are created by Microsoft. Many templates are created by third-party vendors and even by individual users, so there are a number of templates that may work better than others.

Compatibility Mode (Compatibility Mode)

Sometimes, you need to work with spreadsheets that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000 . When you open these types of spreadsheets, they will appear in Compatibility Mode ( compatible mode ).

Compatibility mode disables certain features, so you can only access the commands found in the program used to create the spreadsheet. For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.

In the figure below, you can see that the workbook is in Compatibility Mode , indicated at the top of the file's right window. This will disable some Excel 2016 features and they will be grayed out on the Ribbon toolbar.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 15

To exit Compatibility Mode , you need to convert the spreadsheet to the current version type. However, if you collaborate with others who only have access to an earlier version of Excel, it is best to leave the spreadsheet in Compatibility Mode to change the format.

To convert a spreadsheet:

If you want to access all Excel 2016 features, you can convert the spreadsheet to the 2016 file format .

  1. Note that converting a file may alter the original layout of the spreadsheet.

1. Click the File tab to access the Backstage view.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 16

2. Locate and select the Convert command.

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 17

3. The Save As dialog box will appear. Select the location where you want to save the spreadsheet, enter the file name for the spreadsheet and click Save .

Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets Picture 18

4. The spreadsheet will be converted to the latest file type.

Next article: A comprehensive guide to Excel 2016 (Part 4): How to store and share spreadsheets

Having fun!

5 ★ | 1 Vote | 👨 209 Views
« PREV POST
NEXT POST »