| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling an empty row with the data in row above it
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filling an empty row with the data in row above it
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!* "Donna" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filling an empty row with the data in row above it
Thanks Luke, worked Great
"Luke M" wrote: 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!* "Donna" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filling in empty cells - | Excel Discussion (Misc queries) | |||
| Filling a series into a non-empty column | Excel Worksheet Functions | |||
| Help on filling empty cells with string + row() | Excel Discussion (Misc queries) | |||
| Filling empty cells with a value | Excel Discussion (Misc queries) | |||
| Filling in empty cells in columns | Excel Discussion (Misc queries) | |||
Linear Mode
