Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel

In this lesson, I’m going to be showing you how to:

  1. Copy non-adjacent cells in Excel
  2. 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

34 thoughts on “Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel”

    • 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)

    • 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)

  1. 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)

    • 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)

  2. 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.


    • 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’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)

  3. 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,

  4. 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)

  5. 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)

  6. 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 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)

  7. 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,

    • 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)

    • 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)


Leave a comment

Share via
Copy link
Powered by Social Snap