Excel 2007: The Missing Manual

Chapter 1. Creating and Navigating Worksheets

Every Excel grandmaster needs to start somewhere. In this chapter, you’ll create your first spreadsheet. You’ll learn to move around in it, enter basic information, and save it for posterity. Along the way, you’ll take a quick tour of the Excel window, and stop to meet the different tabs in the ribbon, the status bar, and the formula bar.

Creating a Basic Worksheet

When you first launch Excel, it starts you off with a new, blank worksheet, as shown in Figure 1-1. A worksheet is the grid of cells where you type your information and formulas; it takes up most of the window. This grid is the most important part of the Excel window. It’s where you’ll perform all your work, such as entering data, writing formulas, and reviewing the results.

Here are a few basics about Excel’s grid:

• The grid divides your worksheet into rows and columns. Columns are identified with letters (A, B, C…), while rows are identified with numbers (1, 2, 3…).

• The smallest unit in your worksheet is the cell . Cells are identified by column and row. For example, C6 is the address of a cell in column C (the third column), and row 6 (the sixth row). Figure 1-2 shows this cell, which looks like a rectangular box. Incidentally, an Excel cell can hold up to 32,000 characters.

• A worksheet can span an eye-popping 16,000 columns and 1 million rows. In the unlikely case that you want to go beyond those limits—say you’re tracking blades of grass on the White House lawn—you’ll need ...