MS Excel: How to Create Multiple Sheets in a Workbook

ms-excel-how-to-create-multiple-sheets-in-a-workbook

Are you developing a habit of creating a new excel workbook for everything you do? Well, managing so many microsoft excel files can be tedious at some point. As soon as you will have 50+ files in your folder you may start spending time looking for the desired file. Having too many files can also create confusion.

To avoid the hassle, its always recommended creating 1 workbook for a project or a task. Have multiple excel spreadsheets within that workbook to manage different aspects of it on separate sheets. It makes life quite easy because by doing so you can manage everything related to a task at one place.

Now the question is how exactly you can create and manage multiple spreadsheets within a single excel workbook. And that’s exactly what I am going to cover in this blog post.

Additionally, at the end of the post, I have added 2 power tips for you to help you manage multiple spreadsheets even better.

 

If you don’t have time to read the blog please watch this quick video tutorial of everything that is covered in this blog post. 

 

Click on the banner below to subscribe my YouTube Channel to learn excel and browse more awesome tutorials.

YouTube-subscribe

 

Let’s get started-

How to add multiple spreadsheets in an ms excel workbook?

  • Open Excel workbook
  • Look for the plus icon at the footer adjacent to sheet 1

  • Click on + icon to get new spreadsheet added. You can add as many spreadsheets as you want.

How to delete a spreadsheet?

  • Go to the spreadsheet that you are willing to delete
  • Right-click on sheet title, click on delete

How to rename spreadsheets?

Double click on sheet title and type desired sheet name

 

OR

 

Right-click on sheet title > Rename

How to change the spreadsheet tab colour?

Right-click on sheet title to open menu

Hover your mouse over Tab Colour > Select desired colour

Power Tips

Tip 1 – You can always move your sheets within a workbook by dragging and dropping your sheets

Tip 2 – When you have so many spreadsheets within xlsx workbook, some of the sheets tend to hide underneath the scroll bar. You can always make more space to increase visibility of sheets by dragging vertical triple dot icon towards the right.

Related Articles

 

Leave a Reply

avatar
  Subscribe  
Notify of