EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign up
Home Excel Excel Resources Excel Tips Worksheets in Excel

Worksheets in Excel

Jeevan A Y
Article byJeevan A Y
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated June 7, 2023

Worksheets in Excel

Excel Worksheet (Table of Contents)

ADVERTISEMENT
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

  • What is Worksheet in Excel?
  • How to Create New Worksheets in Excel?

What is Worksheet in Excel?

Worksheets in Excel compiles cells where you hold and modify the data. A worksheet is a name given to the large grid where you perform your calculations. Worksheets are where you store your info, and you typically have more than one worksheet in your workbook.

By default, when we open the workbook, we get 3 worksheets named “Sheet 1, Sheet 2, and Sheet 3”.

workbooks in Excel 1-1

To go to any of the worksheets, we need to just click on that worksheet using our left mouse click.

workbooks in Excel 1-2

As soon as you see the above cursor click your left mouse key, and it will take you to that page, and the view will be of that page only.

If you want to use a shortcut key for quick navigation between worksheets, use the shortcut key below.

  • Ctrl + Page Down: Go to the active sheet’s right side sheets.
  • Ctrl + Page Up: Go to the active sheet’s left side sheets.

How to Create New Worksheets in Excel?

If you want more worksheets, we can insert new ones with just a mouse click. Click on the “PLUS” icon of the sheet tab to add a new worksheet.

workbooks in Excel 1-3

As soon as you click on this button, it will insert a new sheet to the right of the active sheet; for example, in the above image active sheet is “Sheet1” If we click on the insert sheet icon, we will get the new sheet to the right of this sheet.

workbooks in Excel 1-4

Once the sheet is inserted, we can also change the position of the worksheet by moving the worksheet to wherever we want to be holding the worksheet with our left click of the mouse. Before the insertion of the new sheet, the active sheet was “Sheet 1”, but as soon as you insert the new sheet, it will take the place of the active sheet.

workbooks in Excel 1-5

Change the Name of the Worksheets in Excel

Also, at the same time, we can change the worksheet’s name to whatever name we wish to give. For example, we need to change the “Sheet2” name to “Sale Data”, so right-click on the sheet and choose the “Rename” option.

Change Name 1

Now it will highlight the existing sheet name with edit mode.

Change Name 2

Give the name and press Enter key to change the worksheet’s name.

Change Name 3

If you are a shortcut keys fan, use the shortcut key below.

ALT + O + R will immediately take you to the sheet name edit mode.

Change Worksheets Tab Color

We can also change the tab color of worksheets right click on the worksheet name and choosing “Tab Color”.

Change Worksheets Tab Color 1

As soon as you move your cursor on the “Tab Color”, it will show you a different gallery, so choose the desired color you wish to apply for the sheet.

Change Worksheets Tab Color 2

So, the selected color will be applied to the sheet.

Change Worksheets Tab Color 3

We cannot see the sheet tab color exactly now, so select the next sheet to view the tab color correctly.

Change Worksheets Tab Color 4

Change the Default Sheet Count

We can also change the default sheet count of getting 3 worksheets from 3 to any other number. Follow the below steps to change settings.

Step 1: Click on the “FILE” tab in the ribbon.

Step 2: Choose OPTIONS in that window.

Change the Default Sheet Count 1

Step 3: Go to “General” and find “When Creating New Workbooks”.

Change the Default Sheet Count 2

In this, we can change the default font name, size, view, and number sheets to be included. The minimum count should be 1, so you can enter other numbers. Click on “Ok” to close the above settings window, and whenever you open a new worksheet, it will give those many numbers of worksheets as we have provided in the settings.

Things to Remember about Worksheets in Excel

  • By default, we get 3 worksheets.
  • Shift + F11 is the shortcut key to insert a new worksheet.
  • ALT + E + L is the shortcut key to delete a worksheet.

Recommended Articles

This is a guide to Worksheets in Excel. Here we discuss How to make Worksheets in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Group Worksheets In Excel
  2. VBA Worksheets
  3. Unprotect Excel Workbook
  4. VBA Save Workbook
ADVERTISEMENT
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
ADVERTISEMENT
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Footer
Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
  • Blog as Guest
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Cyber Monday Reloaded Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW