Auto Fill a column
 

I have a list in a colum, with blanks in between filled cells.

row value(current) value (desired)
1 AA AA
2 AA
3 AA
4 BB BB
5 BB
6 CC CC
7 CC
8 CC
9 CC
10 DD DD

This is a huge table. Is there any quick solution to autofill?
Thanks.

Auto Fill a column
 

Follow the below steps..It is too easy; but there are 7 steps since I have
elaborated.

1. Select an unused cell out of the data range (say E2)
2. Enter the formula in cell E2 which references the top cell (=E1)
3. Copy the cell (not the formula)
4. Keeping the copy; select the data range in ColA (say A1:A100).
5. Press F5. From Goto windowSpecial from options select 'Blanks'
6. This will select all blanks. Now Right clickPasteSpecialFormulasOK will
fill in with the data you need.
7. Once done you can select col A Copy Paste SpecialValues to turn
formulas to actual values

If this post helps click Yes
---------------
Jacob Skaria


"bean" wrote:

I have a list in a colum, with blanks in between filled cells.

row value(current) value (desired)
1 AA AA
2 AA
3 AA
4 BB BB
5 BB
6 CC CC
7 CC
8 CC
9 CC
10 DD DD

This is a huge table. Is there any quick solution to autofill?
Thanks.

Auto Fill a column
 

Debra Dalgleish shares some techniques he
http://www.contextures.com/xlDataEntry02.html
and a video he
http://www.contextures.com/xlVideos01.html#FillBlanks

bean wrote:

I have a list in a colum, with blanks in between filled cells.

row value(current) value (desired)
1 AA AA
2 AA
3 AA
4 BB BB
5 BB
6 CC CC
7 CC
8 CC
9 CC
10 DD DD

This is a huge table. Is there any quick solution to autofill?
Thanks.

--

Dave Peterson

Auto Fill a column
 

hi bean, try this
assuming you are using column a & b and data is starting from row no. 2,
in cell c2 type the following equation :
= a2
and in cell c3
=if(a3="",b2,c3) ........... copy down the formula as per your requirement

click yes below if it helps

"bean" wrote:

I have a list in a colum, with blanks in between filled cells.

row value(current) value (desired)
1 AA AA
2 AA
3 AA
4 BB BB
5 BB
6 CC CC
7 CC
8 CC
9 CC
10 DD DD

This is a huge table. Is there any quick solution to autofill?
Thanks.