| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Fill formula from a column to row | Excel Discussion (Misc queries) | |||
| How to auto fill cells in column | Excel Discussion (Misc queries) | |||
| How to auto fill with fifth cell in a column? | Excel Worksheet Functions | |||
| Auto Fill, Every other column | Excel Discussion (Misc queries) | |||
| How do I get auto fill to do decending numbers in a column? | Excel Discussion (Misc queries) | |||
Linear Mode
