Copying the same coloumn and pasting it going forward

[adamuce]

Hi.

Before I start: I dont want a macros :D

Is there a way to copy one desired column, and then pasting the same coloumn , without having to select it again after I pasted it.

The reason why I asked is, I have this first column which I need to paste beside other columns. I usually have to copy it first and then paste it before another coloumn. But then I have to copy it again as the selection goes away.

 

[Chihiro]

Use Office clipboard? See link for some detail.
https://support.office.com/en-us/ar...lipboard-714a72af-1ad4-450f-8708-c2931e73ec8a

 

[Peter Bartholomew]

Or you could use an array formula. That way, if you need to change the first block of countries all the others will change to match without manual intervention.

If you name the block from A4 to A15 to be 'Country' then committing
= Country
with CSE from row 20 down will create the repeat blocks you need. Soon dynamic arrays will improve the functionality further provided you are using Office 365.

 

[adamuce]

Good morning thanks to both of you for your suggestions. I will try both of them out :D