Excel 2010 Introduction – Lesson 2 – Entering and Editing Data

Lesson Two: 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.

28

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.

29

  1. Drag the border to the new width

Editing Data

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

30

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.

31

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.

32 33

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.

34

  1. Select Insert Sheet Rows from the Ribbon.

35

The new row is highlighted.

36

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.

37

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

  1. 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.

 38

Leave a Reply