Copyright

How to Modify the Worksheet Tab in Excel

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: Modifying Page Setup Properties in Excel

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:01 Workbook vs. Worksheet
  • 0:45 Excel Worksheets
  • 1:23 Adding, Deleting and…
  • 3:21 Adding Color and…
  • 4:16 Lesson Summary
Add to Add to Add to

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Login or Sign up

Timeline
Autoplay
Autoplay

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Karen Sorensen

Karen has a Bachelors in Communications. She has 25 years of experience in Information Systems, Adult Learning and Virtual Training.

Excel workbooks can have several pages or worksheets. Each page is identified using a worksheet tab. This lesson will review how to add and remove worksheets, how to rename worksheets and how to change the color of the tab fill.

Workbook vs. Worksheet

Just like in Microsoft Word or Microsoft PowerPoint, you can have multiple pages in Microsoft Excel. Sometimes the two terms, workbook and worksheet, can be confusing.

A workbook is the entire Excel file. Some refer to their Excel file as a spreadsheet, but technically, a spreadsheet is one page in a workbook. And, did you know you can have multiple spreadsheets within a workbook? A worksheet is a single page or sheet within the workbook.

This lesson will review the purpose of worksheet tabs, explain where to find them, discuss how to add and remove them, and finally, how to change the fill color of a worksheet tab.

Excel Worksheets

The worksheet is also referred to as the spreadsheet. Think of a workbook as a regular book, in that one book is the entire story, but each page contains a part of the story. Another example would be your personal budget. The entire workbook contains your budget, but you might have one page or worksheet for each month of the year.

The worksheet tabs appear at the bottom of the page. Clicking on the tab takes you directly to that page of your workbook. You can add more worksheets, delete them, change the worksheet title and add a color fill to the tab.

Adding, Deleting and Naming Worksheet Tabs

There are two common ways to add a worksheet. You can use the ribbon commands or use the right-click method. Let's start with the steps to using the ribbon commands.

  1. Start by going to the Home menu in the ribbon.
  2. Then, look in the Cells grouping of commands.
  3. Click on Insert.
  4. Choose Insert Sheet.

Not sure about you, but that's too many steps for me!

I prefer the right-click method. Right-click on any of the worksheet tabs, select Insert from the options menu and click on OK. That's it! Don't worry about the tab title at this point, that comes next.

You can follow the same right-click method to delete a worksheet as well. Right-click on the worksheet tab and choose Delete.

Let me share a quick tip with you. If all you need to do is add a sheet, there is a plus symbol next to the last sheet in the workbook. Click on the shortcut to insert a worksheet.

Now let's take a look at giving the worksheet tab a title. Something a little more detailed than Sheet 1, Sheet 2, Sheet 3, and so on. Again, as with all things related to computer applications, there is more than one way to get something accomplished. You can right-click on the tab and select Rename or you can just double-click directly on the tab title. I prefer the double-click method.

To unlock this lesson you must be a Study.com Member.
Create your account

Register for a free trial

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Free 5-day trial

Earning College Credit

Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it free for 5 days!
Create an account
Support