facebook twitter
Webucator's Free Introduction to Microsoft Excel Tutorial

Lesson: The Backstage View (The File Menu)

Welcome to our free Introduction to Microsoft Excel tutorial. This tutorial is based on Webucator's Introduction to Microsoft Excel 2019 Training course.

In this lesson, you will learn about the Backstage View in Microsoft Excel.

Lesson Goals

  • Learn about the Backstage view.
  • Learn to open a Microsoft Excel workbook.
  • Learn to start a new Microsoft Excel workbook.
  • Learn to use Microsoft Excel templates.
  • Learn to print a Microsoft Excel workbook.
  • Learn to personalize your copy of Microsoft Excel.

Introduction to the Backstage View

The Ribbon, covered in the prior lesson, is where you find all the commands necessary to make changes to your worksheets. Clicking on the tabs in the Ribbon changes the set of commands available to you while you work in your worksheet. After clicking on the File menu, you can no longer see your worksheet or the Ribbon. Instead, you see what Microsoft calls the Backstage view. This is where you:

  1. Manage your current workbook and other workbooks (Save, Open, Close, Print, etc.).
  2. See information about your current workbook (Permissions, Location, Size, Date Last Modified, Author, etc.).
  3. Manage your Excel settings and options (User Interface Options, number of sheets in new workbooks, customize the Ribbon, etc.)

Backstage View

Many of the features of the Backstage view are covered in our intermediate and advanced Microsoft Excel classes. Only those that are essential to working with Microsoft Excel are covered in this class.

Opening a Workbook

There are two ways to open a Microsoft Excel workbook from the Backstage view:

  1. Select Open from the File menu. Open Select a location from which to open the document in the Open section. Open Section In the dialog box that opens up, navigate to the file you want to open and double-click it or select it and click Open. Open Dialog Box
  2. For files you have recently used, select Recent from the File menu and then select the file. Recent Files

Modifying Document Properties

To modify document properties in an Excel workbook, select the File menu tab, and from the Info section, under Properties, type in the text boxes to add document properties.

Modify Properties

Open a Workbook

Duration: 5 to 10 minutes.

In this exercise, you will practice opening Microsoft Excel workbooks from the File menu.

  1. Using the File menu, open My First Workbook.xlsx from the Excel2019.1/Exercises folder.
  2. Close My First Workbook.xlsx.
  3. Open My First Workbook.xlsx from the File menu, using a different method than you used the first time.
  4. Close My First Workbook.xlsx.
  1. File > Open
    1. File > Open
    2. Navigate to Excel2019.1/Exercises.
    3. Select My First Workbook.xlsx and click the Open button.
  2. File > Recent
    1. File > Recent
    2. Click Recent Workbooks (in Excel 2013 and 2016) and click the My First Workbook.xlsx workbook.

New Workbooks and Excel Templates

When creating a new Microsoft Excel workbook, you can choose between creating a blank workbook or creating your workbook from an existing template.

Creating a New Blank Workbook

To create a new blank workbook:

  1. From the File menu, select New:New Command
  2. Click (double-click in Excel 2010) Blank workbook: Blank Workbook Command

Creating a New Workbook from a Template

A template is a predesigned Excel workbook that you can then change to suit your needs. When you create a new workbook from a template, you are creating a copy of the original template.

To create a new workbook from a template:

  1. From the File menu, select New:New Command
  2. In the Search box, search a template category and press Enter. Search
  3. Click a template, and to download it, click Create. Create Command

Modifying a Template

You can modify an Excel template:

  1. Select the File menu, and select New.
  2. Select a template from the list and click Create.
  3. Make the desired changes to the template.
  4. Save the template with a new name. It will by default be saved in the Templates folder.

If you are using Excel 2010, you will follow step 1, and then double click a template category, select a template to view it, and select Download to download it.

Once you've downloaded a template, it is stored in the My Templates location on your computer.

Select, Open, and Save a Template Agenda

Duration: 5 to 10 minutes.

In this exercise, you will create a new workbook using a Microsoft template.

  1. Locate a template to use to create an agenda for a meeting.
  2. Download the template.
  3. Save the workbook as My Agenda.xlsx in your Excel2019.1/Exercises folder.
  4. Leave the file open as we will be using it in future exercises.

Solution:

  1. From the File menu, select New:New Command
  2. In the Search box, search "agendas" and press Enter.
  3. Click a template, and to download it, click Create. Create Command
  4. Click File > Save As:Save As
    1. Navigate to the Excel2019.1/Exercises folder.
    2. File name: type "My Agenda".
    3. Save as type: select "Excel Workbook."
    4. If a dialog box appears asking you if you want to save changes to the workbook template, click No.

Printing Worksheets

The Print window gives you access to several printing and page layout options. You will also see a preview of how your worksheet will print.

To print a Microsoft Excel worksheet:

  1. From the File menu, select Print. Print Command
  2. Choose your print options (number of copies, printer, etc.) and click the Print button. Print Options

Print a Worksheet

Duration: 5 to 10 minutes.

In this exercise, you will print the agenda you created in the last exercise. You will need to have a printer connected to successfully complete this exercise.

  1. Using the File menu, print the agenda you created in the last exercise.

Solution:

  1. File > Print
  2. Select your printer.
  3. Select any additional options you want.
  4. Click the Print button.

Adding Your Name to Microsoft Excel

You can personalize your copy of Microsoft Excel by adding your name. When you do so, the information is used throughout the Microsoft Office products. Excel uses this information for tracking changes and assigning comments and for prefilling data used by some of the built-in templates.

To add your name and initials to Microsoft Excel:

  1. From the File menu, select Options. Options Command
  2. The options you can customize are grouped into categories, which you can see on the left side of the screenshot below. The default category is General. Fill in your name and initials under Personalize your copy of Microsoft Office. Excel Options

Adding a Theme to Microsoft Excel

You can customize how Excel looks (and your other Office programs) by adding a theme. To access themes, from the File menu, select Options. Then select options from the Office Theme drop-down list. You can choose from the options available in the following screenshot: Theme Options