Copy row below
 

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!

Copy row below
 

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

--
Regards,

Peo Sjoblom



"Cathy Landry" wrote in message
...
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!

Copy row below
 

hello,

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

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom



"Cathy Landry" wrote in message
...
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!

Copy row below
 

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


--
Regards,

Peo Sjoblom


"Cathy Landry" wrote in message
...
hello,

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

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom



"Cathy Landry" wrote in message
...
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!

Copy row below
 

Worked great!

Thank you!

"Peo Sjoblom" wrote:

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


--
Regards,

Peo Sjoblom


"Cathy Landry" wrote in message
...
hello,

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

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom



"Cathy Landry" wrote in message
...
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!