Entering, Editing & Deleting Cell Content


To insert Text & Number:


  1. Click a cell to select it.
  2. Type content into the selected cell, then press Enter on your keyboard. The content will appear in the cell and the formula bar. You can also input and edit cell content in the formula bar.

To edit cell content


  1. Select cell and press F2 button on keyboard.
  2. Select cell and click on formula bar.
  3. Select cell and double click on it.

To insert current date & time:


To insert date & time use following shortcut keys.

  1. Ctrl+;              To insert current date.
  2. Ctrl+Shift+:     To insert current time.

To insert formula:


Select the cell and press is equal sign (=) from keyboard.

Select the cell and press is plus sign (+) from keyboard.

Select the cell and press is minus sign (-) from keyboard.

To delete cell content:


Select the cell with content you wish to delete then Press the Delete or Backspace key on your keyboard.

Use the Delete key from your keyboard to delete content from multiple cells at once.

The Backspace key will only delete one cell at a time.

No comments:

Post a Comment