Microsoft Office Tutorials and References
In Depth Information
Taking the Drudgery out of Data Entry
you want to make entries before you begin entering any information. Just
position the cell pointer in the first cell of what is to become the data table
and then select all the cells in the subsequent columns and rows. (For
information on the ways to select a range of cells, see Chapter 3.) After you select
the block of cells, you can begin entering the first entry.
When you select a block of cells (also known as a range ) before you enter
information, Excel restricts data entry to that range as follows:
✓ The program automatically advances the cell pointer to the next cell in
the range when you click the Enter button on the Formula bar or press
the Enter key to complete each cell entry.
✓ In a cell range that contains several different rows and columns, Excel
advances the cell pointer down each row of the column while you make
your entries. When the cell pointer reaches the cell in the last row of the
column, the cell pointer advances to the first selected row in the next
column to the right. If the cell range uses only one row, Excel advances
the cell pointer from left to right across the row.
✓ When you finish entering information in the last cell in the selected range,
Excel positions the cell pointer in the first cell of the now-completed data
table. To deselect the cell range, select a single cell in the worksheet
(inside or outside the selected range — it doesn’t matter) or press one
of the arrow keys.
Be sure that you don’t press one of the arrow keys to complete a cell entry
within a preselected cell range instead of clicking the Enter button or pressing
Enter. Pressing an arrow key deselects the range of cells when Excel moves
the cell pointer. To move the cell pointer around a cell range without
deselecting the range, try these methods:
✓ Press Enter to advance to the next cell down each row and then
across each column in the range. Press Shift+Enter to move up to the
✓ Press Tab to advance to the next cell in the column on the right and
then down each row of the range. Press Shift+Tab to move left to the
✓ Press Ctrl+. (period) to move from one corner of the range to another.
Data entry express
You can save a lot of time and energy when you want the same entry (text,
value, or formula) to appear in many cells of the worksheet; you can enter