fill down empty cells at every change in value
That was it - thank you!
"Gord Dibben" wrote:
Select the column with the blanks then F5SpecialBlanksOK
Type an = sign in active blank cell then point or arrow up to cell above and
hit CTRL + ENTER to fill blanks.
CopyPaste SpecialValuesOKEsc
Gord Dibben MS Excel MVP
On Mon, 23 Mar 2009 11:44:09 -0700, Rose
wrote:
I have a very large spreadsheet where 1 column is a folder path. One path
will be listed, then a random number of blank cells are below it until a
different path is found. What I'm looking for is a command to make the path
fill down into the empty cells below it until it finds a new value, then fill
that value down, etc.
|