Excel 2007 for Starters: The Missing Manual

1.1. Creating a Basic Worksheet

When you first launch Excel, it starts you off with a new, blank worksheet called Sheet1. A worksheet is the grid of cells where you type your information and formulas, and it takes up most of the window, as shown in Figure 1-1. This grid is the most important part of the Excel window. It's where you perform all your work, such as entering data, writing formulas, and reviewing the results. (A collection of one or more worksheets is called a workbook, which is also sometimes called a spreadsheet file).

Here are a few basics about Excel's grid:

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

• The smallest unit in your worksheet is the cell. Cells are the rectangular boxes that store your text or numbers. Excel identifies each cell using a shorthand name derived from the column and row it's sitting in. 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,767 characters.

• A worksheet can span up to 256 columns and 65,536 rows (giving you a grand total of 16,777,216 cells). In the unlikely case that you want to go beyond those limitssay you're naming each one of your brain cellsyou need to create a new worksheet. Every spreadsheet file can hold multiple worksheets, as you'll see in Chapter 5.

• When you enter information, you type it in one cell at a time. However, you don't have to follow any set order. For example, you can start by typing information into cell A40, without worrying about filling any data in the cells that appear in the earlier rows.

The best way to get a feel for Excel is to dive right in and start putting together a worksheet. The following sections cover each step that goes into assembling a simple worksheet. This worksheet will track household expenses, but you can use the same approach to create any basic worksheet.

1.1.1. Starting a New Worksheet

When you fire up Excel, it opens a fresh workbook. If you've already got Excel open and you want to create another workbook, just select File New. Contrary to what youd expect, this step doesn't actually create the new file. Instead, it pops up the New Workbook task in the Task Pane (if that isn't already visible). To finish the job, you need to click the "Blank workbook" link.

1.1.2. Adding the Column Titles

The most straightforward way to create a worksheet is to design it as a table with headings for each column. Even for the simplest worksheet, the decisions you make about what's going to go in each column can have a big effect on how easy it is to manipulate your information.

For example, in a worksheet that stores a mailing list, you could have only two columns: one for names and another for addresses. But if you create more than two columns, your life will probably be easier, since you can separate first names from street addresses from Zip codes, and so on. Having multiple columns means that you can sort (reorganize) your spreadsheet information in lots of ways: by last name, by state, or however you like. Figure 1-3 shows the difference.

You can, of course, always add or remove columns later. But you can avoid a lot of tedious cutting and pasting by starting a worksheet with all the columns you think you'll need.

The first step in creating your worksheet is to add your headings in the row of cells at the top of the worksheet (row 1). Technically, you don't need to start right in the first row, but unless you want to add more information above your headingslike a title for the chart or the date you're creating itthere's no point in wasting the blank space.

For a simple expense worksheet designed to keep a record of your most prudent and extravagant purchases, try the following three headings:

• Date Purchased stores the date when you spent the money.

• Item stores the name of the product that you bought.

• Price records how much it cost.

Right away, you face your first glitch: awkwardly crowded text. (The standard width of an Excel column is a paltry 8.43 characters.) To widen columns, as shown in Figure 1-4:

1. Position your mouse on the right border of the column header you want to expand.

   The mouse pointer changes to the resize icon (it looks like a double-headed arrow).

2. Drag the column border to the right as far as you want.

   As you drag, a tooltip appears, telling you the character size and pixel width of the column. Both of these pieces of information play the same roletelling you how wide the column is. Only the unit of measurement changes.

1.1.3. Adding Data

You can now begin adding your data: simply fill in the rows under the column titles. To do so, just click in any cell you want to add data to, and then start typing. When you're finished with that cell, move onto the next cell by clicking in it. Keep repeating this enter-info-then-click tango till you're done adding all your data.

Each row in the expense worksheet represents a separate purchase that you've made. (If you're familiar with databases, you can think of each row as a separate record.) As Figure 1-5 shows, the first column is for dates, the second column is for text, and the third column holds numbers. Keep in mind that Excel doesn't impose any rules on what you type, so you're free to put text in the Price column. But if you don't keep a consistent kind of data in each column, you won't be able to easily analyze (or understand) your information later.

That's it. You've created a living, breathing worksheet. The next two sections explain how to edit data and move around the grid.