Filling an empty row with the data in row above it

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?
 
L

Luke M

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.
 
D

Donna

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Macros to check whether all cells are filled 0
Having Blank Cells, etc. ? 1
how to delete some rows without data which comes in between rows with data 4
Comparing columns of data? 0
Matching Rows with Multiple Columns in Two Worksheets 0
How do I insert a row or rows between each row of text and copy the row above? 0
Deleting/removing unused rows in a worksheet 3

Top