Office 2010 - Excel

Lesson 2: Introduction to Excel 2010 (2)

2/87 Lessons 

The “File” tab

For those of us who have worked with the 2007 version of “Excel”, the “Office Button” (1) has disappeared. This button has been replaced by the “File” tab (2).
Clicking this tab takes you to the “Backstage” view.


The “Backstage” display (1)

The “Backstage” view is divided into three parts.

In the left part (1), we find four buttons at the top for the most common commands in Excel.
I suppose everyone knows what they do, but I want to mention the keyboard shortcuts for these commands:

  1. “Save” = Ctrl S
  2. “Save as” = F12 (Shift+Ctrl+S on a Mac)
  3. “Open” = Ctrl O
  4. “Close” = Ctrl W

In the left bottom part, we have a number of tabs. “Info”, “Recent”, “New”, “Print”, “Save and Send” and “Help” buttons plus “Options” and “Exit”. Each tab has a number of options.

The “Info” tab will be selected, when we click the “File” button when an Excel file is open(ed). This tab gives us the information about the opened file.

In the middle column we find the commands, “Permissions”, “Prepare for Sharing” and “Versions”. With the “Permissions” button, we can protect a workbook in whole or in part. With the “Prepare for Sharing”, we check the file access and interoperability for the file that we are going to share with third parties and with the “Versions” button, we can restore unsaved versions of files, the ones that we have closed without saving them.

In the right part (3) of the window, we have the properties of the opened file. You can add a title, tags and / or categories on which you can later perform a search in Windows 7.


The second tab is the “Recent” tab. Under the “Recent” tab, we find a list of recently opened workbooks in the middle column (2), and a list of recently opened places (locations) (3) of these workbooks in the right column. The list of recently opened workbooks can contain up to 50 files.

By clicking on the pushpins (a) next to the file, you can attach the file to the list


The file (a) will be moved to the top of the list, no matter how many files you have open. The file is pinned at the top of the list and will always appear. To disconnect this pinned file from the list of sticky files, click again on the pushpins (a).
To delete a file from the list of recent workbooks or from the list of pinned files, right click the file and choose the “Remove from list” option in the drop-down menu.



Note! When you delete a file from the list of recent workbooks, you do not remove it from your computer, just from this list.

You've completed Lesson 2