i have a column with blanks cells and i want to fill them with the last cell
with a value...how can i do that?

If you have something like this:

Value
Value
(Blank)
(Blank)
Value
(Blank)
Value

and you want to have each blank cell display that last value above it...
try this:

Select the range of values and blanks

Press the [F5] key.......a shortcut for <edit<go to
Click the [special] button.....Check: Blanks......Click [OK]

While the blank cells are selected
Press [F2]....Type: =.....Press the UP arrow one time...
Hold down the [Ctrl] key and press [Enter]

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)



"Gaby" wrote in message
...
i have a column with blanks cells and i want to fill them with the last
cell
with a value...how can i do that?