Microsoft Office Tutorials and References
In Depth Information
Creating a Basic
This rudimentary expense list has
three items (in rows 2, 3, and 4). The
alignment of each column reflects
the data type (by default, numbers
and dates are right-aligned, while
text is left-aligned), indicating that
Excel understands your date and
That’s it. You’ve now created a living, breathing worksheet. The next section explains
how you can edit the data you’ve entered.
Every time you start typing in a cell, Excel erases any existing content in that cell.
(You can also quickly remove the contents of a cell by just moving to it and pressing
Delete, which clears its contents.)
If you want to edit cell data instead of replacing it, you need to put the cell in edit
mode , like this:
Use the mouse or the arrow keys to get to the correct cell.
Edit mode looks almost the same as ordinary text entry mode. The only
difference is that you can use the arrow keys to move through the text you’re typing
and make changes. (When you aren’t in edit mode, pressing these keys just
moves you to another cell.) If you don’t want to use F2, you can also get a cell
into edit mode by double-clicking it.
Once you’ve modified the cell content, press Enter to make your change or Esc
to cancel your edit and leave the old value in the cell. Alternatively, you can click
on another cell to accept the current value and go somewhere else. But while
you’re in edit mode, you can’t use the arrow keys to move out of the cell.
Tip: If you start typing new information into a cell and decide you want to move to an earlier position in
your entry (to make an alteration, for instance), just press F2. The cell box still looks the same, but you’re
now in edit mode, which means that you can use the arrow keys to move within the cell (instead of
moving from cell to cell). You can press F2 again to return to the normal data entry mode, which allows you to
use the arrow keys to move to another cell.