Excel - how to fill blank cells with value from above

[arcusmarie]

Hello

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?

[#2]

@arcusmarie 

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.

[#3]

Thank you @Hans Vogelaar 

[#4]

Thank you@Hans Vogelaar