In this lesson, I’m going to be showing you how to:
- Copy non-adjacent cells in Excel
- Paste the cells as adjacent columns in another spreadsheet in Excel
Go ahead, open the video below and watch the tutorial at your own pace:
If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)
Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂
Watch this tutorial directly on our YouTube channel and Subscribe
Thanks for watching!
Do you want to learn to create your own website?
If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.
CLICK HERE to read our review about this amazing learning platform, if you want to know more.
When you’re ready move onto:
Lesson 22: How to RENAME a worksheet in Excel
Or go back to:
Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?
Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?
Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?
Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel
Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel
Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel
Lesson 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?
Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel
Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit
Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells
Lesson 10: How to use the INSERT FUNCTION command in Excel
Lesson 9: Simple Subtraction Formula in Excel
Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data
Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel
Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel
Lesson 5: Average Function in Excel | What does Average mean
Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel
Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive
Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons
Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)
Hope you are enjoying your learning 🙂
Habib Ali – ICT Tutor

Hi Habib,
Thanks for the training. Now, I am going to give it a shot. As simple as it is, I was struggling with this.
Thanks again.
You found it I see Benson – I have just left you a reply comment for this lesson, which you requested. Well done and hope this was beneficial for you. Take care
Habib (ICT tutor)
Wow. Thank you so much! These things are so simple when you know how, but so frustrating when you can’t figure them out!
Absolutely Chris – this is why everyone needs direction and tutoring. All my lessons are free, so please do take advantage of them 🙂
Habib (ICT Tutor)
Inspite of of Excel’s usefulness, it is overlooked by most people.
Excel is a tool that can help you organize, record, and track down important things.
Having a tutorial like yours would be helpful to everybody whether you’re an affiliate marketer, business owner or even a housewife.
Your tutorial is very easy to follow. Thanks for sharing.
I totally agree with you Mina. It is a big shame people are not using excel as much as they could do. I am trying to break down all technical terms for excel, then hopefully everyone will find it a lot easier to understand and use excel 🙂
Habib (ICT Tutor)
Hi Habib,
Excel drives me mad, but in this lesson, you make things so clear. I learned a lot from this post and for this I thank you.
Sandi
You’re welcome Sandra. Excel is a complex package, so unless it is explained and demonstrated correctly then one will find it difficult and be put off by it. My lessons are very clear and to the point. Try starting from lesson 1 and completing them all. Take care 🙂
Habib (ICT Tutor)
Thanks for the training, I think it’s comprehensive to know how to copy & paste the non-adjacent cells into another spreadsheet. I may need to come back often to check all the excel tutorials shared on your website.
Matt
It is very important to know how to transfer or copy cells from one spreadsheet to another, so you can always transfer your data to another spreadsheet, even as a backup.
Habib (ICT Tutor)
You present as an expert in your field and break points down in a simple manner. Easy to understand! Ty
Thank you Ekufaa, I am an ICT tutor by profession. It is my job to break it down and make learning as easy as possible 🙂
Habib (ICT Tutor)
Excel is still so relevant in this day and age, and I often find myself stuck not knowing how to do some specific task or another. Thanks for the lessons, Habib!
You’re welcome Tom – Excel is more valuable than ever, as more and more of us are becoming independent and doing things for ourselves and not relying on other professionals to do it for us, such as our accounts and charging us hundreds of pounds. A little knowledge can save us a lot of money 🙂
Habib (ICT Tutor)
Hi,
Thank you for this article. Your information is so valuable. I am always following your tutorials to find out more. Today, I learned how to copy cells from one spreadsheet to another spreadsheet in Excel.
Kind regards,
Yoana
Great Yoana – happy to hear it. Keep on learning. I aim to have at least one tutorial a day published here on our site and on our YouTube channel. So please do feel free to subscribe to our YouTube channel by clicking here.
Habib (ICT Tutor)
Excel tips and tricks always come in handy and you have done an excellent job with explaining in this lesson. I have always copied the non adjacent columns separately but this was so cool to learn. Keep teaching, Habib.
Thank you Debbie for your kind words and encouragement. A lot of people like yourself do copy and paste individual columns, which takes longer. Now, you know how to save time by copying non-adjacent cells by holding down the ctrl key on the keyboard.
Habib (ICT Tutor)
Hi mate,
I was struggling before with Excel, but not anymore.
Your tutorials are great, good job.
Cheers
Happy to help Marian mate :). Start from lesson 1, I think it will be more beneficial for you.
Habib (ICT Tutor)
This article is so helpful. I never use excel so I don’t even really know the basics. This is very helpful and explained in a way even a novice can do it. Thank you for the tips!
Yes Erika, it must be explained very thoroughly but in a way that anyone can understand. Being a qualified ICT tutor, I am well aware of how important this is. Keep on learning 🙂
Habib (ICT Tutor)
This is excellent! I am following up on all your lessons, because I am using Excel more often now, and I need to refresh my previous knowledge of it. Your lessons are helping me so much! Keep on sharing!
Thank you Christine. I will keep on sharing if more and more people like yourself are taking advantage of my free lessons.
Habib (ICT Tutor)
Great site! I love working with excel and you have made the tips and tricks easy to follow. Well done.
Thank you Eleanor for the kind words. I have many tips up my sleeves, and I will be sharing many more with you on the future tutorials I am creating. Take care
Habib (ICT Tutor)
I honestly should be looking at all those tutorials as I am certainly not very good with Excel. And to be skilled with Excel would be so very useful for many reasons.
Yes Manuela, Excel skills are very important these days. I suggest you start from lesson 1 to get the best out of my tutorials.
Habib (ICT Tutor)
Hi Habib,
I always like watching your videos, they are very clear and accurate.
I also appreciate your purpose, because Excel is very important for everybody who wants to work in a multinational company or in an office.
Thank you for sharing,
Andrea
Yes Andrea, you have rightly so identified the importance of excel skills, which could be used in any office setting or for personal use for budgeting. Take care
Habib (ICT Tutor)
Very simply put. I can easily follow. Great videos. Thanks
Thank you for your comment, much appreciated. I will always make my tutorials very simple to follow and understand.
Habib (ICT Tutor)
Hi. I really like your site, so much so that I am going to bookmark it and try your tips.
Thank you Dave, and happy to help. You will find many more tutorials here on our site and many more are on their way. I do recommend you start from lesson 1. Take care
Habib (ICT Tutor)