Spreadsheets: Getting Started, Part II   

  Back     Forward    "Getting Started" Home    Excel Review Home

 

II. Basic Data Entry
    Entering Text and Numbers
    Editing an Entry
    Deleting an Entry
    Adding or Deleting a Row or Column
    For More Information

 

Entering Text and Numbers

Click with the mouse on the cell in which you want to enter data to make that cell the current cell. Begin typing the entry for that cell. When your entry is complete, hit the enter key.

Excel automatically left justifies text and right justifies numbers, but you can easily override these defaults with formatting commands.

Notice that while you're typing an entry into a cell, the entry also displays in the formula bar. Any time you make that cell the current cell, the cell's contents display in the formula bar. If you enter a formula in the cell, the formula itself displays in the formula bar while the evaluated result of the formula displays in the worksheet.

Return to Top

 

Editing an Entry

To edit the contents of a cell double-click the cell with the mouse. Excel changes the mouse pointer to a vertical edit bar within the cell. Change the cell contents and then hit the enter key to exit cell edit mode.

Alternatively, make the cell you want to edit the current cell. Then click the mouse in the formula bar and perform the edit operation in the formula bar instead of in the cell itself.

Return to Top

 

Deleting an Entry

Make the cell whose entry you want to delete the current cell. Then hit the Delete key to delete the cell's contents.

Delete the contents of a range in the same way you'd delete the contents of a single cell.

Return to Top

 

Adding or Deleting a Row or Column

It's easy to make changes to your spreadsheet layout by adding or deleting rows or columns.

For example, to add a single column, click the header of the column to the right of where you want the new column to be located. The entire selected column will appear in reverse video. Select Insert, Columns from the main menus and Excel adds a new column to your worksheet. To insert more than one column at a time select more than one column header before choosing the menu instructions. Inserting an additional row or rows works the same way. Select the row or rows below where you want the new row to be located.

Delete a row or column by selecting its header and clicking Edit, Delete or hitting the Delete key.

Return to Top

 

For More Information

- Click Help on the top-level menu. Then select Contents and Index, select the Index tab and on the Contents tab select Editing Worksheet Data.

Return to Top