Microsoft Office 2000

Lesson 3: Excel 2000 (Part 1)

Working With Worksheets and Workbooks

This lesson will teach you how to enter data into your worksheet.

To enter data:

• Place the cursor in the cell in which you would like to enter the data
• Type the data
• Press Enter or click in another cell

Use AutoFill to enter data in a series such as months or dates.

To use AutoFill:

• Enter the first item in the sequence into a cell
• Move the cursor to the tiny square in the lower right corner of that cell
• The cursor will turn into the AutoFill handle (which looks like a small black + sign)
• Click and drag the AutoFill handle over all the cells you want to include in the sequence

See example of AutoFill

You can also move or copy cells from one location to another.

To move cells:

• Select the range of cells you wish to move by clicking on the first cell, pressing and holding the Shift key, and clicking on the last cell in the range
• Move the cursor to the border of the range. Note that the cursor will turn into the standard Windows pointer
• Click and drag the range to the new location

See example of selecting cells to Move

See example of Moving cells

To copy cells:

• Select the range of cells you wish to copy by clicking on the first cell, pressing and holding the Shift key, and clicking on the last cell in the range
• Move the cursor to the border of the range. Note that the cursor will turn into the standard Windows pointer with a small + sign above it
• Press and hold the Ctrl key as you click and drag the range to the new location

See example of Copying cells

You can also use the Menu options (under Edit) to cut (move), copy, and paste cell contents.

To use the Menu options to cut, copy, and paste:

• Select the range of cells you wish to move or copy
• Click on the Menu option you wish to use (Edit – Cut or Edit – Copy)
• Move the cursor to the new location
• Click on the Menu option Edit – Paste

Resizing Rows and Columns
At times you will need to resize rows and columns. Text that is too wide for the current size of the cell will be truncated and numbers will appear as ######.

To resize a cell to accommodate an entry:

• Click and drag the column or row heading to the appropriate width or height
• You can also double-click the column or row heading to automatically resize it

To move around more quickly in an Excel worksheet, it is a good idea to become familiar with keyboard shortcuts. See Table 11.1 Keyboard Shortcuts for Moving Within a Worksheet in Microsoft Office 2000 for Windows: Visual QuickStart Guide p. 123.

For additional information on this topic browse Chapter 5 Editing Excel Worksheets in Microsoft Office 2000 User Specialist Study Guide.

  1  2  3  4