Back To Course
Intro to Excel: Essential Training & Tutorials15 chapters | 70 lessons
Video: How to Modify the Worksheet Tab in Excel
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.How to Modify the Worksheet Tab in Excel
You must create an account to continue watching
Register for a free trial
Are you a student or a teacher?
Start Your Free Trial To Continue Watching
As a member, you'll also get unlimited access to over 70,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.
Free 5-day trialIt only takes a few minutes to set up and you can cancel at any time.
Already registered? Login here for access
Back
Your next lesson will play in
10 seconds
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.
- Start by going to the Home menu in the ribbon.
- Then, look in the Cells grouping of commands.
- Click on Insert.
- 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.
After you double-click on the title, Excel opens the text box for editing. Type in the new title and you are good to go. In the lesson video, our example is the personal budget workbook. Notice that we have 12 worksheet tabs, titled with each month of the year.
Adding Color and Modifying the Text
It is always nice to be able to add a bit of variety to the tabs with color. The steps to changing the tab color are about as simple as they can get. Right-click on the tab, choose Tab Color from the options menu to open the color palette and select a color. If you don't find what you want in the standard colors, click on More Colors. After you select your color, step off the tab (just click on a different tab). This will apply your selection to the tab.
Unfortunately, Excel does not let you change the color, size or font of the title text. However, Excel does a nice job of automatically changing the color of the font, depending on the background color - it actually changes it in order to create contrast.
Lesson Summary
This lesson reviewed the difference between a workbook and a worksheet. You learned that a workbook can have several worksheets or pages. Each page is referred to as a spreadsheet and they can be accessed using the worksheet tabs along the bottom of the screen.
Worksheet tabs can be added and removed by right-clicking on the tab and selecting either Insert or Delete. You can also rename the tab and change the tab fill color.
Using worksheet tabs can help to keep Microsoft Excel workbooks organized.
Learning Outcomes
After you've watched this video on how to modify the worksheet tab in Excel, you should be able to:
- Recall what a workbook is
- Describe the two common ways of adding a worksheet
- List the steps to adding color and modifying text
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 MemberAlready a member? Log In
BackEarning 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.
You are viewing lesson
Lesson
1 in chapter 2 of the course:
- How to Modify the Worksheet Tab in Excel 4:58
-
6:18
Next Lesson
Modifying Page Setup Properties in Excel
- How to Insert & Delete Columns & Rows in Excel 6:26
- Workbook Themes: Applying & Changing Themes in Excel 4:54
- Adjusting Column Width & Row Height in Excel 6:56
- How to Insert Watermarks in Your Excel Worksheet 5:08
- How to Insert Headers & Footers in Excel 5:29
- Using Data Validation in Excel 6:27
- Go to Formatting Worksheets & Workbooks in Excel
How to Modify the Worksheet Tab in Excel Related Study Materials
- Computer Science 202: Network and System Security
- Veterans in the Workplace
- Religious Inclusion in the Workplace
- CSET Spanish Subtest III (147): Study Guide & Practice
- Praxis Elementary Education - Instructional Practice & Applications (5019): Study Guide & Practice
- Network Auditing & Configuration
- Wireless Network Security
- Introduction to Network Security
- Network Authentication
- Network Encryption
- AFOQT Cost
- What Does the HESI A2 Nursing Exam Consist of?
- How to Learn Pharmacology for NCLEX
- What Are Considered Higher-Level Questions on the NCLEX?
- How to Study for NCLEx in 2 Weeks
- How Hard Is the ASVAB
- How Long is the HESI A2 Nursing Exam?
Latest Courses
- Teaching Students with Moderate & Severe Disabilities
- Coordinate Geometry Definitions & Formulas
- Dislocated Coccyx: Symptoms & Treatment
- Dante's Inferno Eighth Circle of Hell: Punishments & Description
- Managing Software Projects: Challenges & Processes
- Veteran Discrimination in the Workplace: Conscious & Unconscious Bias
- Passing & Using Array Addresses in C Programming
- Covariance & Correlation: Equations & Examples
- Quiz & Worksheet - Supporting Students with Communication Disorders in Schools
- Quiz & Worksheet - Accounts Receivable Journal Entries
- Quiz & Worksheet - Improving Learning with Media
- Quiz & Worksheet - Social Behavior Data Collection in the Classroom
- Quiz & Worksheet - Treating Concrete Burns
- Flashcards - Measurement & Experimental Design
- Flashcards - Stars & Celestial Bodies
Latest Lessons
- ASVAB Mathematics Knowledge: Study Guide & Test Prep
- AP Biology Syllabus Resource & Lesson Plans
- Business Ethics: Skills Development & Training
- Remedial Algebra II
- Assessing Globalization Opportunities for a Business
- Holt McDougal Earth Science Chapter 19 - Stars, Galaxies, and the Universe
- Ancient Greek Civilization
- Quiz & Worksheet - Newton's Third Law Calculations
- Quiz & Worksheet - Demand, Cost & Inventory Management
- Quiz & Worksheet - Skip Counting
- Quiz & Worksheet - Angle of Reflection
Popular Courses
- The Importance of the Front Desk in a Medical Office
- Bond Energy: Definition, Equation & Calculations
- How to Study for a Science Test
- Essay Prompts, Rubric & Instructions for The American Civil War Era
- How to View Grades and Export CSVs in Your Study.com Virtual Classroom
- Common Core State Standards in Wisconsin
- How to Pass the Series 66
- How to Pass the Chemistry Regents Exam
- Macbeth Project Ideas
- Fun Math Games for 6th Grade
- What is Professional Development for Teachers?
- What is the Math Olympiad Contest?
Popular Lessons
Math
Social Sciences
Science
Business
Humanities
Education
History
Art and Design
Tech and Engineering
- Tech and Engineering - Videos
- Tech and Engineering - Quizzes
- Tech and Engineering - Questions & Answers
Health and Medicine
Explore our library of over 70,000 lessons
Browse by subject
