Copy row below

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
If you delete the blank row (using edit>delete) the next row below will take
it's place
 
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
 
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...
 
Back
Top