Problem copying with Row Heights

[dunmore83]

Hi,

I need to copy B3:AG26 & paste the exact contents (including row heights) below into B29.

I cannot seem to find a way to do this so that the row heights are the same when pasted??

Please help if you know!

Cheers!!

 

[Andrew Poulsom]

Are you able to copy the entire row? That way row heights will also be copied.

 

[dunmore83]

Excellent thank you!!

 

[dunmore83]

Another question on this.

Highlighting the rows works to copy & paste this selection, with row heights.


But it does not preserve the cells which i have locked & protected.

Do you know how to copy & paste a selection within a spreadsheet so that the same cells are protected & locked in the pasted area??

Cheers

 

[Andrew Poulsom]

Pasting also pastes the Locked property of the cells.