facebook google plus twitter
Webucator's Free Introduction to Microsoft Excel 2013 Tutorial

Lesson: The Backstage View (The File Menu)

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

In this lesson, you will learn to work with the Backstage View (The File Menu).

Lesson Goals

  • Open a Microsoft Excel workbook.
  • Start a new Microsoft Excel workbook.
  • Use Microsoft Excel templates.
  • Print a Microsoft Excel workbook.
  • 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 workbbooks, customize the Ribbon, etc.)

Please note that there is no FILE menu or Backstage view in Microsoft Excel 2007.

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. File Open Select a location from which to open the document in the Open section (in Excel 2013 only). 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

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 Excel2013.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.

Solution:

  1. File > Open
    1. FILE > Open
    2. Navigate to Excel2013.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 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:File New
  2. Click (double-click in Excel 2010) Blank workbook: New Blank Workbook

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:File New
  2. In the Search box, search a template category and press Enter. Search Template
  3. Click a template, and to download it, click Create. Create Template

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.

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.

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 Excel2013.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:File New
  2. In the Search box, search "agendas" and press Enter.
  3. Click a template, and to download it, click Create. Create Template
  4. Click FILE > Save As:File Save As
    1. Navigate to the Excel2013.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. File Print
  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. File Options
  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 Dialog Box

Managing Workbook Versions

Excel automatically saves documents as you work with them. You can manage these auto-saved versions from Backstage view.

To set options for managing these, click Options in Backstage view and in the Excel Options dialog box, select Save. You will see autosave options here. Excel Options Dialog Box

To delete autosaved workbooks:

  1. From the FILE menu tab, select Info, if necessary.
  2. Under Versions, you will see any auto saved versions. Versions
  3. To delete one, right-click it and select Delete This Version.