Filling an empty row with the data in row above it

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I have a spreadsheet that is about 12,000 rows deep, with about 1000 rows
that are blank, basically blank rows to show a data change, I don't want to
delete the row but fill it with the data that is directly above it. Is there
an easy way to do this. Or does someone have a macro?
 
Highlight all of your data, then press Ctrl+G to bring up the GoTo dialogue.
Under Special, click "blank cells".

Type "=", then press the up-arrow key (should create a formula reference
cell directly above current active cell).

Press Ctrl+Enter to apply formula to all selected cells. Voila!

If you want static values, select all of your data again, copy, paste
special - values.
 
Thanks Luke, worked Great

Luke M said:
Highlight all of your data, then press Ctrl+G to bring up the GoTo dialogue.
Under Special, click "blank cells".

Type "=", then press the up-arrow key (should create a formula reference
cell directly above current active cell).

Press Ctrl+Enter to apply formula to all selected cells. Voila!

If you want static values, select all of your data again, copy, paste
special - values.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
Back
Top