Copy row below

C

Cathy Landry

Hello,

I have a huge spreadsheet that I've inserted a blank row in between my data,
now I need to copy the entire row below into the blank row above it.

Any suggestions?

Thank you!
 
P

Peo Sjoblom

If you delete the blank row (using edit>delete) the next row below will take
it's place
 
P

Peo Sjoblom

Select the whole range, press F5, click special and select blanks

type an equal sign and hit the down arrow, then press ctrl + enter

It might take a while if it is large, also before you do this make a copy of
the workbook in case you are doing it incorrectly
 
C

Cathy Landry

Worked great!

Thank you!

Peo Sjoblom said:
Select the whole range, press F5, click special and select blanks

type an equal sign and hit the down arrow, then press ctrl + enter

It might take a while if it is large, also before you do this make a copy of
the workbook in case you are doing it incorrectly
Click to expand...
 
Top