What is the quick way to replicate a data range, for example:
AB12
AB34
AB56
AB78
AB89
I want to replicate this range 10 times, all in the same column.
Thank you in advance.
What is the quick way to replicate a data range, for example:
AB12
AB34
AB56
AB78
AB89
I want to replicate this range 10 times, all in the same column.
Thank you in advance.
You have 5 rows (say A1:A5) filled.
Select all
Copy (Ctrl+C)
select a cell under
Ctrl+G -> write A6:A55 -> OK
Paste (Ctrl+V)
A6:A55 because it will fit ten times 5 rows
Best Regards,
Kaper
Thanks, and a star for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks