Excel - how to fill blank cells with value from above

Question

Hello&nbsp;I have a spreadsheet with approximately 300 rows of data and I need to fill in the values in the blank cells based on the rows above. Online it says to do this by selecting the blanks, which I've done, then I enter =A2 in cell A3 and press control and enter at the same time. However, I've done this and what happens is that the values aren't copied but instead it enters =A2 into each blank cell. I'm sure I must be making a stupid error / mistake but i can't seem to figure it out. Please can you help?

hansvogelaar · Answer

arcusmarie&nbsp;
I suspect that columns A and B are formatted as text.
Go back to the situation where the cells are blank.
Select columns A and B.
Select General as number format.
Press F5 or Ctrl+G.
Click Special...
Select Blanks, then click OK.
Enter the formula =A2 and press Ctrl+Enter.

arcusmarie · Answer

Thank you&nbsp;HansVogelaar&nbsp;

sharadapanda · Answer

Thank you@Hans Vogelaar&nbsp;

tara_data_ols1626 · Answer

This was very useful, Thank you!

mani1 · Answer

This was a great help..thank you so much HansVogelaar

Forum Discussion

Excel - how to fill blank cells with value from above

Resources