Follow Us

Your Personal and Professional Development: Plans, Tips and Lists

Powered by Bookboon, your personal eLibrary with 1,700+ eBooks on soft skills and personal development

Excel 2016: Using Worksheets and Workbooks

Posted in Articles

How to keep record and find your data fast and easy

Excel can be compared to a real book and we call that book a “workbook”. A workbook can contain one or several pages, which in Excel, we call “worksheets”. Now, imagine a workbook containing lots of information all mixed-up in only one worksheet; for instance, a company’s financial statement for five long years. Would you be able to locate specific information, like a month’s report, easily? Obviously, the answer is NO. That’s when the idea of having multiple worksheets becomes handy. Excel indeed is a great tool, especially for record-keeping, and of course, finding.

Adding worksheets to existing workbooks

Most of the time, we need to add worksheets on our workbook to organize the contents of our file. To add worksheets –

  1. Click on the plus sign next to Sheet1.


  1. Keep adding sheet tabs until you have as many as you need.


Deleting Worksheets

The easiest way is to Right Click on the sheet tab you want to delete and then select Delete, as shown below. The worksheet will be deleted immediately.



Copying worksheets

If you want to have duplicate copy of a worksheet, just follow these steps:

  1. Right click on the worksheet tab.
  2. Select Move or Copy Sheet.


  1. Tick Create a copy.
  2. Select where you want to place the copy.
  3. Click Ok.


Moving worksheets

Aside from the step indicated above, sequence of your worksheets can also be changed by following this technique: Click and drag on the sheet tab to move it then drag this to the location you wish to place it.



Renaming a worksheet

To have a more meaningful and organized workbook, you can rename your worksheets instead of using the usual Sheet1, Sheet2, etc.

  1. Double click on the sheet tab. (Current name will be highlighted.)


  1. Type your preferred name and then click away to confirm.


Grouping worksheets

When worksheets are grouped together, whatever you do in one sheet will automatically be done to the others. Through this, you can apply formatting and create formula to all of the sheets in the group at once.

  • Grouping worksheets that are next to each other
Click on the picture to extend it.
  1. Click on the first Sheet tab.
  2. Hold down the Shift key.
  3. Click on the last Sheet tab that you require.
  4. The Sheet Tabs of the sheets that are grouped will turn white if not colored and go pale if they have color applied.
  • Grouping worksheets that are not next to each other


Click on the picture to extend it.


  1. Click on the first Sheet tab.
  2. Hold down the Control key.
  3. Click on any other Sheet tabs that you require.
  4. The Sheet Tabs of the sheets that are grouped will turn white or go pale.


Changing worksheet tab color

When you have many worksheets, changing the tab color will be helpful in recognizing the one you need.


  1. Right Click the Worksheet tab.
  2. Click on Tab Color.
  3. Choose the color from the color palette.


Hiding worksheets

  1. Right click on the worksheet tab you wish to hide.
  2. Select Hide.



Un-hiding worksheets

  1. Right click on a worksheet tab.
  2. Select Unhide.


  1. Click on the worksheet you wish to unhide.
  2. Click OK.

Customizing your Excel 2016 workbook is as easy as 1, 2, and 3! These steps are done not only to make it more appealing, but also to make it more structured and organized.

We have even more useful articles:


Excel 2016 Core Part One

Read more tips and tricks by downloading Shelley Fishel’s eBook "Excel 2016 Core Part One".

Read more