Starting a Workbook

Use the Excel new workbook or Excel new worksheet feature to create new files, insert and delete text, and navigate an Excel worksheet.

Introduction

TextYou will need to know how to insert text and numbers into Excel workbooks to be able to use it to calculate, analyze, and organize data. In this lesson, you will learn how to create a new workbook, insert and delete text, navigate a worksheet, and save an Excel workbook.

Your first workbook

To create a new blank workbook:

Select New
New Workbook Dialog Box

When you first open Excel, the software opens to a new blank workbook.

To insert text:

Select Cell
Insert Text

Cell addresses

Each cell has a name, or a cell address, based on the column and row where it is located. For example, this cell is C3 because it is where column C and row 3 intersect.

Cell Address

You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.

If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel. Review our Extra on What are Reference Styles? to learn how.

To edit or delete text:

You can also make changes to and delete text from the formula bar. Just select the cell, then place your insertion point in the formula bar.

To move through a worksheet using the keyboard:

To save the workbook:

Saving Workbooks

You can save a workbook in many ways, but the two most common ones are as an Excel Workbook, which saves it with a 2007 file extension, and as an Excel 97-2003 Workbook, which saves the file in a compatible format so people who have earlier versions of Excel can open the file.

Compatibility mode

Sometimes you may need to work with workbooks that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000. When you open these kinds of workbooks, they will appear in Compatibility mode.

Compatibility mode disables certain features, so you'll only be able to access commands found in the program that was used to create the workbook. For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.

Compatibility mode

If you want access to all features of Excel 2007, you can save the workbook in the Excel 2007 file format.

To exit Compatibility mode:

Saving Workbooks

Challenge!