Forum Discussion
Excel - how to fill blank cells with value from above
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, whic...
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.
This was very useful, Thank you!