GCFLearnFree.org

This is exactly what I am looking for. My students will love this site.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2010
  • Cell Basics

Excel 2010

Single page view print copy

Cell Basics

Cell content

Each cell can contain its own text, formatting, comments, formulas, and functions.

  • Text
    Cells can contain letters, numbers, and dates.
  • Formatting attributes
    Cells can contain formatting attributes that change the way letters, numbers, and dates are displayed. For example, dates can be formatted as MM/DD/YYYY or M/D/YYYY.
  • Comments
    Cells can contain comments from multiple reviewers.
  • Formulas and functions
    Cells can contain formulas and functions that calculate cell values. For example, SUM(cell 1, cell 2...) is a formula that can add the values in multiple cells.

To insert content:

  1. Click on a cell to select it.
  2. Enter content into the selected cell using your keyboard. The content appears in the cell and in the formula bar. You also can enter or edit cell content from the formula bar.
    Inserting content Inserting content

To delete content within cells:

  1. Select the cells containing content you want to delete.
  2. Click the Clear command on the Ribbon. A dialog box will appear.
  3. Select Clear Contents.
    Clearing cell contents Clearing cell contents

You can also use your keyboard's Backspace key to delete content from a single cell or the Delete key to delete content from multiple cells.

To delete cells:

  1. Select the cells you want to delete.
  2. Choose the Delete command from the Ribbon.
    Deleting cells Deleting cells

There is an important difference between deleting the content of a cell and deleting the cell itself. If you delete the cell, by default the cells underneath it will shift up and replace the deleted cell.

previous next
previous 1 2 3 4 5 6 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.