Select the entire range of cells, say A2:A1000, with cell A2 being the active
cell. Then goto Edit - Go to, click special, and select blanks. Only the
blank cells should be selected now.

Next, type "=", and then press the down arrow (if active cell is A2, this
creates the formula =A3). Next, hold down Ctrl, and press enter (this inputs
formula into all selected cells).

you can now leave the data as is, or do a copy - paste special - values, to
get static values.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"deeds" wrote:

I am trying to fill a range of blanks with the data at the bottom of the
selections. Example: I want to fill the "x" cells above the 200 with 200, I
want to fill the "x" cells above the 450 with 450...etc I used the DigDb
tool but was wondering if there is another solution out there...thanks.

x
x
x
200
x
x
x
450