Sunday, December 23, 2012

How to Use Autofill With Numbers in Excel 2007


Autofill the Same Number
1. Type the number in the first cell that you would like to contain that number.
2. Click on the cell to highlight it.
3. Click the small square in the lower-right corner of the cell and hold the mouse button down.
4. Drag the square in whichever direction you would like to AutoFill. Release the mouse button when all desired cells are highlighted. The value is copied into the cells.
Autofill a Sequence
5. Type the first two numbers of your sequence in the first two cells in your list. For instance, to start an integer sequence in the 'A' column you would type '1' in cell A1 and type '2' in cell A2.
6. Highlight the cells that contain the first two numbers in your sequence.
7. Click the small square in the lower-right corner of your selection and hold the mouse button down.
8. Drag the square in the direction that you would like to autofill. Release the mouse button when all desired cells are highlighted. Sequential values are copied into the highlighted cells.

Blogger news