Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filling in blanks.
I have a large spreadsheet, it has names and blanks in column A. I want to
fill in the blanks with the name above the blanks with out having to do it manually. Any ides??? |
#2
|
|||
|
|||
Hi,
If you know how to write and run a macro... sub filldown() range("a1:c10").select 'you can either enter the range 'here or leave this line out and highlight the range 'before you run the macro selection.specialcells(xlcelltypeblanks).select selection.formulaR1C1="=R[-1]C end sub peter -----Original Message----- I have a large spreadsheet, it has names and blanks in column A. I want to fill in the blanks with the name above the blanks with out having to do it manually. Any ides??? . |
#3
|
|||
|
|||
Assume A1 has a name.
Select column A. Hit F5 and SpecialBlanks. Enter an = sign in the active cell then point to cell above and hit CRTL + ENTER. With column A still selected, copy and in place Paste SpecialValuesOKEsc. Gord Dibben Excel MVP On Wed, 24 Nov 2004 11:09:07 -0800, "S. Kissing" <S. wrote: I have a large spreadsheet, it has names and blanks in column A. I want to fill in the blanks with the name above the blanks with out having to do it manually. Any ides??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filling a cell | Excel Discussion (Misc queries) | |||
Trailing blanks | Excel Discussion (Misc queries) | |||
Average the last 5 of a continually filling row. | Excel Discussion (Misc queries) | |||
Zero Filling | Excel Discussion (Misc queries) | |||
filling a series | Excel Discussion (Misc queries) |