Entering Data in Your Worksheets

You can enter data in your worksheets by typing it, by pasting it, or by using drag and drop to move or copy it. Excel also includes a feature called AutoFill that automatically fills in series data for you based on the input you've provided.

Typing Data in a Cell

To enter data in a cell, first make the cell active by clicking in it or moving the selection rectangle to it. Then start typing in the cell. As you start typing, Excel displays an insertion point in the cell, and what you type appears in the cell.

When you've finished typing the contents of the cell, move to another cell in any of these ways:

  • Press Enter. Excel moves the active cell to the next cell below the current cell.
  • Press Tab. Excel moves the ...

Get Office 2010 Made Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.