AutoFill isnt working?

M

M.L

i typed 1 on cell A1 , and drag the square around the cell but it fills the
below cells with the number 1 instead of 2,3,4,5,6,.................
Please help
Thanks
 
G

greg7468

Hi,
Or you can right click on the black square, drag down and select fill
series upon release if that helps.

HTH.
 
S

Sanjay Kumar via OfficeKB.com

Put "2" in 'A2', and drag it down after selecteion.
If you already have contents in column 'B' say till row number 34.
If you select 'A1:A2' and double-click the cross at the bottom of A2, it will
fill incremented data till 'A34"
 
D

dsm

Try typing 1 in cell A1, 2 in cell A2, then highlight A1 + A2, then grab the
corner and drag down.
 
T

tjtjjtjt

Try putting 2 in the next cell, select both cells and then drag down.
--or--
After you type the 1, hold down Ctrl as you drag down.
 
S

SVC

To fill a series, Excel needs to know the pattern to follow. Inserting 1 and
dragging down is the same as copying. Insert 2 in A2, select A1 and A2, then
drag.

Alternately, if you have a large number of cells to fill, you can used Edit
Fill > Series
Click to expand...

Select Series in Column, Type is Linear, Step value is 1, Stop value is the
last number you want to appear. You can also choose a different step (e.g.
2) and Excel will increment subsequent cells by this number, starting with
the number you inserted in the cell to start the fill in.
 
Top