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