Creating a New Workbook

Learning Objectives

  • Create a new Excel workbook.

You can open Excel from the Start menu (or the Applications folder on a Mac) by clicking on the Excel icon. The Excel icon comes in a variety of forms depending on your OS and version of Excel, but it always features the color green and the letter X.

Four different versions of Microsoft Excel logos are displayed.

When you open Excel, some versions of Excel may take you straight to a new blank workbook. Newer versions such as Excel 2016 will take you to a menu called backstage view to choose to open a new blank workbook or open a new workbook from a template. If you already have a file open in Excel, you can create a new document by clicking File>New. You can also use the shortcut Ctrl+N (Command+N for Mac).

The backstage view of a Microsoft Excel sheet is open on a windows computer.

Note that the backstage view on a Mac computer is a little different.

The backstage view of a Microsoft Excel sheet is open on a Mac.

Practice question

 

To open a blank workbook, double-click the blank workbook option.

A blank Microsoft Excel document is open.

Before using a workbook, it is helpful to know a few key terms.

Practice Question

 

A blank Microsoft Excel document is open. There are three numbers and three different boxes. Each number and box are matched by a color. The first box is green and represents where a cell is. The second number and box combination is orange and shows where a row is. The third box is pink and it represents where the columns are. The fourth box represents the tabs beneath where data is entered. There is only one tab, and it is labeled Sheet1.

  1. Cell. This is the area where you will enter data.
  2. Row. Rows are cells aligned horizontally.
  3. Column. Columns are cells aligned vertically.
  4. Worksheet. A worksheet is a single page within a workbook. Like the tabs in an internet browser, the tabs in an Excel workbook show different pages, or worksheets. A workbook may have many worksheets included in it. In this screenshot, the workbook only has one worksheet and one tab, which is labeled Sheet1. The selected tab shows the selected worksheet. Clicking the + button will add another worksheet. When you save a workbook in Excel, all of the worksheets in that workbook are saved.