Lesson 35 – How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

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

  1. Insert a NEW worksheet in-between 2 worksheets in Excel
  2. Rearrange worksheets in Excel
  3. Rename worksheets 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 36 – Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!

Or go back to:

Lesson 34 – What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

Lesson 33 – How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Lesson 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Lesson 31 – Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 30 – Best method to format numbers to display as PERCENTAGES in Excel

Lesson 29 – Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28 – A simple DIVISION formula in Excel | How to DIVIDE in Excel

Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25 – Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24 – How to SORT data in ASCENDING order in Excel

Lesson 23 – Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22 – How to RENAME a worksheet in Excel

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

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 (£) and apply 2 Decimal places to numbers in Excel?

Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?

Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?

Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

38 thoughts on “Lesson 35 – How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel”

  1. A great lesson again. First of all, thank you so much for sharing. This video is very clear so that I could learn how to insert and rename a worksheet in Excel step-by-step. Honestly, I could learn a lot of techniques for using Excel from watching your videos. Please keep it up. Looking forward to more great videos.

    All the best,

    Alex

    Reply
    • Thank you Alex – you have motivated me to carry on making many more tutorials on Excel. If my visitors benefit, then I will not stop making tutorials on Microsoft Office. Take care

      Habib (ICT tutor)

      Reply
  2. Hi Habib ,i really like your way of teaching excel .You makes it so simple to understand and the pace is also very good .Some teachers would go fast that it is very hard to follow what they are teaching .Thank you for this lesson Habib

    Reply
    • Thank you very much. Any good teacher will know the pace to go at for others to follow and learn. I’m happy you are learning from my excel lessons. But please start from lesson 1 and complete them all as they are series of lessons. Take care

      Habib (ICT tutor)

      Reply
    • Thank you – the lessons are designed in a sequential manner, so everyone can learn and be educated step by step like you said.

      Habib (ICT tutor)

      Reply
  3. I never knew how to do this, thank you so much for sharing. This will be really valuable for so many people. Do you have any tutorials on Excel formulas?

    Reply
    • You’re welcome Catherine – happy to help as always. I have many tutorials on Excel formulas. Here are some:

      Lesson 1 – Simple multiplication Formula using Excel
      Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel
      Lesson 3 – Simple Subtraction Formula using Excel
      Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?
      Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?
      Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?
      Lesson 7 – What is the ROUND function, and how to insert it in Excel?
      Lesson 8 – What is the IF function, and how to insert it in Excel?
      Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

      Habib (ICT tutor)

      Reply
  4. Very nice, easy to follow and straightforward video on how to rename and move Excel sheet. The Excel program is very helpful tool for everyone who is working in some way or another with computers or online. As you said it is like folding the files, but you don’t need a huge folder, taking so much space of your apartment. That’s why people will always search for the ways how to correctly use it and therefore you are providing value to the folks. Great and keep on working this way. Thank you.

    Reply
    • Thank you for your valuable feedback Julius, and explaining some good points of needing different worksheets and having them organised and arranged in a systematic order. This is the way to go 🙂

      Habib (ICT tutor)

      Reply
  5. Hi,

    I had no idea how to rearrange a worksheet, and you’ve really explained this so well in your tutorial.

    I’m enjoying working my way through your tutorials. They are super clear and I’m able to follow every step that you make.

    Reply
  6. Hi Habib,
    Thanks for the tutorial. Now, I can create a worksheet in-between worksheet. I don’t know if you have done a tutorial on reducing the number of data in a worksheet by copying and pasting the excess into another blank worksheet. I have a worksheet with data over 3000 but want to break them into 1000 each so that my analyzer can perform at an optimum level.
    This is a great tutorial can’t wait for the next one. Definitely will share it.

    Reply
    • You’re welcome Benson. Please look at lesson 21, where I’m showing how to transfer data from one spreadsheet to another. This should be helpful for you. I will have another lesson on Monday and am not going to tell you the topic or title, so you can have a look for yourself – it is just 2 days away 🙂

      Habib (ICT tutor)

      Reply
  7. I have not had the need for Spreadsheets at all and I am a complete newbie on the subject.
    I am interested in learning and it looks like you have a ‘ton’ of lessons on it.

    Thanks for the great post at WA on the subject.

    Joe Joson
    USNavy Retired

    Reply
    • You’re very welcome Joe – welcome to excel learning. You will love all my lessons as they are sequential and easy to learn, even for newbie like yourself. Please start from lesson 1 🙂

      Habib (ICT tutor)

      Reply
  8. This really got me over the issue I have been having recently and couldn’t find a way to fix anywhere but here!

    So thank you so much for showing how to insert a new worksheet between 2 existing ones..I’ll be back for sure.

    Great tutorial.

    Reply
    • Happy to hear you’re problem is now fixed by this video lesson. You can come back anytime you want and please do start from lesson 1 to make the most of my lessons on excel. Take care

      Habib (ICT tutor)

      Reply
  9. Hi Habib and Rani,
    I really took ICDL a few years ago and in which I learned the basics of Excel. With the help of your videos, I refresh what I learned and add some new information.
    Best wishes to you
    Rania

    Reply
    • That’s great to hear Rania. Refreshing skills is a must, otherwise they do get a little rusty. Our video lessons will always be here on our site and YouTube channel for you to come back to and revise from. Take care

      Habib and Rani

      Reply
  10. It’s news to me that you can insert a new worksheet in between 2 worksheets, so another learning experience brought courtesy of your hacks and tips!

    I love renaming worksheets, it makes life so much easier, especially with the monster files I have to navigate. I sometimes even create a cover page with links to each worksheet.

    Reply
    • That’s a great idea of creating a cover page and links to different worksheets – I will put this on my list of tutorials to create. Take care 🙂

      Habib (ICT tutor)

      Reply
  11. I never even knew that you can insert a new worksheet in between two worksheets in excel. That’s a brilliant idea! It’s amazing how much there is to learn about excel and I love how you simplify it and make it easy to understand in your tutorials! Thank you!

    Aminah

    Reply
    • Thank you Aminah for your kind feedback – learning should always be simple, but well explained, so one can understand straightaway. Happy to help you today to understand and carry out, how to insert a worksheet between 2 existing worksheets in excel. Take care

      Habib (ICT tutor)

      Reply
  12. OMGoodness you have done it again! I did not know that some of these excel options were even available! I am starting to feel like an excel genius! Keep them coming! Thanks!

    Reply
    • That’s great to know Brianna. My job is to let you know of all the amazing excel features via my video lessons and you’re job is to carry on learning from the daily lessons 🙂

      Habib (ICT tutor)

      Reply
  13. This is so helpful. There are so many things in Excel I need to learn and one of them was inserting a new worksheet in-between 2 worksheets.

    I can’t still believe I paid for an Excel course when you give all of this advice for free.
    Many thanks

    Reply
  14. Wow, I’ve been trying to learn excel better, and this has been the most helpful thing to see thus far. You should continue to make more of these please. I will keep coming back! Very helpful.

    Reply
  15. Hi Habib,

    Thanks for another great Excel tutorial!
    I always return here if I’m in need of some help with the program. Definitely gonna recommend your website to my colleagues as well!
    It will make things a lot easier and save us valuable time to do other things 🙂

    Kind regards,
    Catherine.

    Reply
    • Thank you Catherine – happy to serve you with our video lessons on excel. Excellent idea to share with your colleagues and let them benefit too 🙂

      Habib (ICT tutor)

      Reply
  16. Great lesson! Thanks for sharing such helpful information. I never knew how to rearrange a worksheet so this lesson was so helpful for me!

    Reply
    • Thank you Alyse – happy to have helped you with rearranging worksheets in excel. There are many more lessons on excel on our website. I recommend you start from lesson 1 🙂

      Habib (ICT tutor)

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap