How to copy 2 ranges of cells and keep their spacing

[mr_samd]

Hi,

I want to copy a row of 4 cells, then a 1 cell space, then another 5 cells all in one go.
Is this possible? I have tried with holding Ctrl and selecting both ranges, but when it is pasted it pastes it without the 1 cell gap. Its just 9 cells all next to eachother.

Any help would be appreciated.

Sam

 

[frank_AL]

Put your cursor in the leftmost cell then hold down CTRL and Shift then press the Right arrow key 3 times. This will select all 10 cells as one block to copy and paste.

 

[mr_samd]

That worked great thank you!