Creating a New and Opening Existing Workbooks in MS Excel 2016

All the files that you create in MS Excel are known as workbooks. In order to create a new project in MS Excel you need to create a new workbook. In order to create a new workbook you can either opt for a blank workbook or go for a predesigned template. You can also open an existing workbook. You can also learn about some Keyboard Shorcuts used in Windows 10

Creating a New Blank Workbooks

In order to create a new blank workbook you need to follow these simple steps.

  • 1st of all you need to select File tab. After selecting the File tab a Backstage view will appear.
  • Now in this view you have to select New and after that you have to click on Blank workbook option.
  • Once you click on Blank workbook option a new blank workbook will be created.

Opening an Existing Workbooks

Apart from creating new workbooks you can also open a workbook that has been saved previously. In order to open an existing workbook you need to follow these simple steps.

  • 1st of all you need to click File and then navigate the Backstage View.
  • Now you need to click Open option.
  • After clicking Open option you will be guided to a new window from where you need to select Computer and then click Browse.
  • Now after clicking the Browse option Open dialog box will be opened.
  • In the Open dialog box you need to locate the workbook and then select and open it.
  • This will open the existing workbook.

Creating a New Workbook from a Template

In order to create a new workbook from a predesigned template you need to follow these simple steps.

  • 1st of all you have to click the File tab and then access the Backstage view.
  • In the Backstage view you need to click on New option.
  • After this you will notice that several templates will appear below the Blank workbook option.
  • Now you need to select the template of your choice.
  • Once you select the template you will see the preview of the template along with some added information.
  • Now click on create option for using the selected template.