Excel : Entering and Editing Data

This module introduces you to your first worksheet, where you can enter or edit data.
Your worksheets will have a purpose in mind, whether it is to add a series of numbers,
like sales figures or expenses, or to track things like inventory or class registrations. Time
spent thinking about the structure of your worksheet will pay off later, but you can also
add rows and columns at any time to rearrange your data. This module will also
introduce the ability to wrap cell contents and check your spelling.

Entering Data

Data is entered into cells. Click the cell you want, and type the desired entry. You can
enter either numbers (VALUES) or text (LABELS) in Excel.
Once you have finished typing, you can press Tab or Enter to complete the entry.
When you type data into a cell, all of it is contained in that cell, even if it is not all visible
at once. If you cannot see all of the data in your cell, you can widen the column.
In the following example, “Household Budget” and “Car Payment” are both too long for
the column width.

Use the following procedure to widen a column.

1. Click on the column you want to widen. Notice the cursor changes to a cross with
   double arrows. The screen tips indicate how wide in pixels the column currently
   is.
2. Drag the border to the new width

Editing Data

Shown here is the relationship between the active cell and the Formula Bar.

Using the Wrap Command

Use the following procedure to wrap the contents of a cell that contains a label.

1. Click the cell that you want to wrap.
2. Click the Wrap Text tool on the Ribbon.

Use the following procedure to force a line break in a cell with wrapped contents.

1. Click on the cell with wrapped contents. The contents appear in the Formula Bar.
2. Place your cursor on the Formula Bar where you would like to force a line break.
   Press Alt+ ENTER.

Adding Rows and Columns

New columns are inserted to the left of your currently selected column, and new rows
are inserted above your currently selected row.
Use the following procedure to add a new row.

1. Highlight the row below where you want to insert a row. Click to the left of the
   row number to highlight the whole row.

2 . Select Insert Sheet Rows from the Ribbon.

The new row will be highlighted.

Checking Your Spelling

To check your spelling, display the Review tab, and click the Spelling button (in the
Proofing group).
Use the following procedure to check spelling.

1. Select the Spelling tool on the Review tab of the Ribbon

Excel opens the Spelling dialog box and begins indicating any spelling errors.

2. Highlight the correct spelling and select Change. If the correct spelling is not
   listed, you can correct the spelling by editing the text in the Not in Dictionary
   field.