Microsoft Office Tutorials and References
In Depth Information
Storing Stuff in a Spreadsheet
Enter. Excel selects the next cell down in that same column. When Excel
reaches the last cell in the column, it selects the top cell of the column to the
To select multiple cells for typing data in, follow these steps:
1. Highlight multiple cells by choosing one of the following:
• Move the mouse pointer over a cell, hold down the left mouse
button, and drag (move) the mouse to highlight multiple cells.
Release the left mouse button when you’ve selected enough cells.
• Hold down the Shift key and press the up/down/right/left arrow
keys to highlight multiple cells. Release the Shift key when you’ve
selected enough cells.
Excel selects the cell that appears in the upper-left corner of your
2. Type a number, label, or formula.
3. Press Enter.
Excel selects the cell directly below the preceding cell. If the preceding
cell appeared at the bottom of the selected column, Excel highlights the
top cell in the column that appears to the right.
4. Repeat Steps 2 and 3 until you fill your selected cells with data.
5. Click outside the selected cells or press an arrow key to tell Excel not
to select the cells any more.
Typing in sequences with AutoFill
If you need to type the names of successive months or days in a row or
column (such as January, February, March, and so on), Excel offers a
shortcut to save you from typing all the day or month names yourself. With this
shortcut, you just type one month or day and then drag the mouse to
highlight all the adjacent cells. Then Excel types the rest of the month or day
names in those cells automatically.
To use this shortcut, follow these steps:
1. Click a cell and type a month (like January or just Jan ) or a day (like
Monday or just Mon ).
The Fill Handle, a block box, appears in the bottom-right corner of the