Familiarizing Yourself with the Excel Screen
Figure 43.1 shows the opening Excel screen. Your screen might
Figure 43.1. Familiarize yourself with Excel's opening screen.
Understanding Workbooks and Worksheets
Excel enables you to create and edit
. A workbook holds one or more
). A worksheet is a collection of rows and
Blank Excel workbooks contain three worksheets named
, as shown at the bottom of Figure 43.1. When you click a sheet's tab, Excel
Every cell in your workbook contains a unique name or address to which you can refer when you are tabulating data. The cell address of the active cell (the cell that the cursor is in) appears at the left of the Formula bar. In Figure 43.1, the box reads A1 because the cursor is in cell A1 .
When you move your mouse pointer across Excel's screen, notice that the pointer becomes a cross when you point it to a cell area. The cross returns to its pointer shape when you point to another part of the Excel work area.
Inserting Worksheets in a Workbook
Just as Word enables you to edit multiple documents in memory at the same time, Excel enables you to edit multiple worksheets
To insert a new worksheet into your workbook, right-click the worksheet tab that is to fall
the new worksheet. Select Insert from the pop-up menu. Excel displays the Insert dialog box, as shown in Figure 43.2, on which you can double-click the Worksheet icon and press OK. The Insert dialog box contains several kinds of items that you can add to a workbook, but worksheets are the most common items you add. The Insert, Worksheet command also
Figure 43.2. Add a new worksheet to your workbook.
Deleting Worksheets from a Workbook
Situations arise when you only need a single worksheet in a workbook. You might want to track your monthly household budget, for example; such a budget rarely requires multiple worksheets. For your budget, the workbook is basically the same as the worksheet, but you should pare down excess worksheets instead of wasting memory on them. Excel makes it easy to delete excess sheets. Just right-click the tab of the sheet you want to delete and select Delete from the pop-up menu.
Working with Multiple Worksheets
To specify the maximum number of worksheets that a workbook is to hold, select Tools, Options, click the General tab, and enter a number in the Sheets in New field labeled Sheets in New Workbook. When you create a new workbook, that workbook contains the number of sheets you
Figure 43.3. The Options dialog box enables you to specify how many worksheets to include in your workbooks.
One interesting workbook feature is the capability to rearrange worksheets within a workbook, and even to move worksheets between two or more workbooks.
If you don't like the current order of the worksheets in your workbook (the worksheet tabs
Working with Multiple Workbooks
As your workbook fills up with worksheets, you need a way to manage those worksheets and move from one to another. When you then want to copy or move information from one to another worksheet, you can easily do so.
If you need to move a worksheet from one workbook to another, open both workbooks and select Window, Arrange, Tiled to display both worksheets, as shown in Figure 43.4. Drag one of the worksheet tabs to the other workbook to move the sheet. To copy instead of move, hold Ctrl while you drag the sheet name.
Figure 43.4. Display both workbooks if you want to move or copy worksheets or cells between them.