web analytics

Cell Content (Part 1)

Any data you enter a spreadsheet is stored in a cell. Each cell can contain various content types, including text, formatting, formulas, and functionality.

  • Text:Cells can have text in a form of letters, numbers, and dates.
  • Formatting attributes:Cells may contain formatting attributes that alter the way they view letters, numbers and dates. Percentages will appear, for example, as 0:15 or 15 percent. You may also alter the text or background colour of a cell.
  • Formulas and functions: Formulas and functions that measure cell values may be used in cells. SUM (B2:B8) adds the value of each cell in the B2:B8 cell range in our example and displays the sum in cell B9.

Inserting content:

  1. Click a cell to choose it. In our example, we will choose cell F9.
  • Type something into the selected cell, then in your keyboard, press Enter. In the cell and the formula bar, the content will appear. In the formula bar, you can also input and edit cell material.

Deleting (or clear) cell content:

  1. Choose the cell(s) with content you want to delete. In our example, we will choose the cell range A10:H10.
  • Select the Clear command on the Home tab, then click Clear Contents.
  • The contents in the cell will be deleted.

You can also employ the Delete key on the keyboard to delete content from multiple cells simultaneously. The Backspace key deletes content from just one cell at a time.

Deleting cells:

A major difference occurs between removing a cell’s contents and deleting the cell itself. If the whole cell is removed, the cells below will be transferred to fill the holes and cover the deleted cells.

  1. Choose the cell(s) you want to delete. In our example, we will select A10:H10.
  • Pick the Delete command from the Home tab on the Ribbon.
  • The cells below will move up and fill in the gaps.