How to Remove Useless Worksheets in Excel


So what do you do when your colleague sends you an Excel workbook with three or more pages? Well what’s the problem with that?? I will tell you – most of the time there is only one page in that workbook with data in it, which makes the other two pages useless in my humble opinion.

So let’s get rid of them! Did you know you could change the default number of worksheets in your Excel workbook? Well you most certainly can!

Follow the steps below to learn how:

  1. Click on your File tab and select Options.
  2. On the General tab of your Excel Options dialog box, change the Include this many sheets option to 1.

excel options

But wait! Suppose you have an instance when you actually need more worksheets in your workbook? Very simple operation.

Follow the steps below to learn how:

  • Click the small Insert Worksheet button to the right of your sheet tabs or if you want to save time, simply click Shift + F11.

insert excel sheet

Suppose you have a bunch of worksheets in your workbook already but need another one? And suppose you do not see that little Insert Worksheet button?


You can always do it this way:

  • On the Home tab of your Ribbon, in the Cells group, click the dropdown arrow on the Insert option and select Insert Sheet.

You can always scroll to the right to see that little button too.

But if you are like me and I have taught you well, you will want the most efficient method of adding that worksheet and this to add the Insert Worksheet command to your Quick Access Toolbar (QAT).

Follow the steps below to learn how:

  1. Right-click anyplace on your Ribbon and select Customize Quick Access Toolbar.
  2. From the Choose Commands from drop down, select All Commands.
  3. Scroll about half-way down and select the Insert Worksheet command.
  4. Click Add.
  5. Click OK.

There you have it! Nice and easy.


 

Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

There are 4 comments

Your email address will not be published. Required fields are marked *