Hey! you can try the following steps...
Assume you're having the data in column "A".
* Select the full data range.
* Press "F5" or "Ctrl + G". The "Go To" window opens.
* Click "Special" button at the bottom left.
* Then click "blanks" & give "Enter".
* Without disturbing any cell, write "=" & press the up arrow.
* Then give "Ctrl + Enter"
So the shortcut after selecting the range will be as follows...
"F5" + "Alt S" + "K" + "Enter" + "= ?" + "Ctrl + Enter"
Lemme know if this works!
I have a similar problem with a small difference that I have the text in one cell and then several empty cells, then one nonblank cell and several empty cells. I would like to fill the empty cells with the text of the preceeding nonblank cell. When I tried the proposed formula =if (isblank(a2), a1, a2) in the adjucent column it gave me the desired result in the immediately following cell (because the above cell is not blank in the adjucent column) but after that started giving out "0" because in the adjucent column the cell is empty. How it is possible to bypass this problem? Please help
=if (isblank(a2), a1, a2) says that if A2 is blank then show the value of a1, other wise show a2. So I am kind of lost. This is my best understanding. You are saying if there are more than one blank cell it gives a 0
if that is the case you can try
=if (isblank(a2), if(isblank(a1), b1, a1), a2)
this says if A2 is blank, then see if A1 is blank. If a1 is blank then show value from b1 else show value of a1. In case A2 is not blank then show value from A2