Fill blank cells with an if formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Help needed 0
Fill last row down for large selection? 1
Macro Fill Formula 1
Excel Macro to automatically go to the right of the last colored cell 0
fill blank cells in a column 1
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
help with formula for last input in column 6

Back
Top