Copy row below

[Guest]

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!

 

[Peo Sjoblom]

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

 

[Guest]

hello,

I need to copy the row below thus making a duplicate row of data.

 

[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

 

[Guest]

Worked great!

Thank you!

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