Excel is a widely used spreadsheet program. While it’s most popularly known for its ability to make use of heaps of data, Excel has an infinite number of capabilities, from making lists and charts to organizing and tracking information.
Learn moreCourses
- Microsoft Excel - Basic & Advanced
- Microsoft Excel - Basic
- Microsoft Excel - Advanced
- Microsoft Excel - Pivot Tables
- Microsoft Excel - Macros and VBA
- Microsoft Excel - Dashboards
- Microsoft Excel - Power Query
- Microsoft Excel - Power Pivot
- Microsoft Excel for Mac - Basic
- Microsoft Excel for Mac - Advanced
- Microsoft Excel for Mac - Basic & Advanced
- + 3 more courses
Resources
Whether you want to do XLOOKUP, COUNTIF, CONCATENATE or simply merge cells, we’ve got you covered with step-by-step guides to the most important tools, formulas, and functions in Excel.
See resourcesCertification
90% of offices use Excel. Getting Excel-certified can be highly beneficial for job seekers. Get certificates in multiple Excel courses to prove your proficiency in Excel.
See certificationMicrosoft Office
Learning Microsoft Office has significant benefits for your daily workflow, productivity, and career possibilities. Microsoft Office skills are indispensable across a plethora of industries and professions.
Learn moreCourses
- Microsoft Excel - Basic & Advanced
- Microsoft Word - Basic & Advanced
- Microsoft PowerPoint 365
- Microsoft Outlook
- Microsoft Teams Training
- Microsoft OneNote Training
- Windows 11 for Beginners
- SharePoint Online
- Microsoft Visio Training
- Microsoft Planner and Project for the Web
- Microsoft Project Fundamentals
- + 15 more courses
Resources
Looking for help with Microsoft Office? Check out our free guides with tips on how to maximize the potential of apps like Word, PowerPoint, Teams, Excel and more!
See resourcesLean Six Sigma
Lean Six Sigma provides a structured problem-solving methodology that can be used to address any type of problem. Being able to find and fix problems will improve your ability to perform in any position and industry.
Learn moreCourses
- Intro to Lean Six Sigma
- Lean Six Sigma - Yellow Belt
- Lean Six Sigma Principles - Green Belt
- Lean Six Sigma Advanced Principles - Black Belt
- Statistical Process Control
- Measurement Systems Analysis
- Hypothesis Testing
- Failure Mode and Effects Analysis
- Design of Experiments
Resources
Deepen your understanding of popular LSS tools and techniques, and simplify complex LSS concepts with our thorough how-to guides and resources.
See resourcesCertification
Lean Six Sigma certification can fast track your career and boost your pay packet. Certified Lean Six Sigma professionals are among the highest paid globally. Get trained in LSS!
See certificationFinance
Whether you are in HR, Sales, IT, Admin or Support, you need to speak the language of finance. Whether discussing plans, strategy or how well your department is performing, you’ll be conversing in financial terms and numbers.
Learn moreCourses
- Finance for Non-Financial Professionals
- Finance for Operations Managers
- Finance for Project Managers
- Finance for Operations Directors
- Financial Modeling Basics
- Financial Modeling Techniques
- QuickBooks Online
Resources
From accounting software tips, to taxes and financial modelling techniques, our resource center has free guides to help you gain the finance knowledge you are looking for.
See resourcesProject Management
Project management jobs are in high demand with not enough skilled applicants to fill them. For qualified candidates, project management roles are available in almost every industry.
Learn moreCourses
- Project Management Basics
- Project Management Bootcamp
- Project Management Framework
- Project Teams and Stakeholders
- Project Planning
- Project Performance and Delivery
- Project Management for Engineers
- Project Meetings
- Microsoft Planner and Project for the Web
- Microsoft Project Fundamentals
- CAPM Certification Training
- + 6 more courses
Resources
Explore our resource center to find templates to help you get the job done, job interview tips, insights to tackle your biggest project management challenges, and so much more.
See resourcesCertification
It pays to be certified in project management. You need to complete 35 hours of PM training from an ATP to get your certification. We can help you meet that requirement.
See certificationOffice Productivity
How successful could you be if you were more productive? Master widely-used productivity tools like Trello, Todoist, and Google Drive to optimize your workflow and spend time doing the work that truly matters. Start getting things done!
Learn moreCourses
- Keynote for Mac
- 1000minds Decision-Making
- Trello
- Google Drive & Apps
- Todoist
- Essential Productivity Training
Resources
Having difficulties adjusting to remote work? Need help with work-life balance? Need tips on how to use tools like Zoom or Slack effectively? Try these resources!
See resourcesLeadership & Management
Good leaders employ a comprehensive set of hard and soft skills to act as the oil of a well-functioning machine. While some of these traits are expressions of their inherent personality, most are learned and refined over time.
Learn moreCourses
- Leadership Training
- Team Leadership
- Deliver Effective Criticism
- Listening Skills
- Speaking Skills for Leaders
- How to Conduct a Job Interview
Resources
Finding yourself in need of simple tools and guidance to navigate through challenging situations as a leader? Take a look at our resources for management tips and strategies that you can implement right away.
See resourcesSoft Skills
Soft skills matter a lot in the workplace. Here’s why. As the workforce grows more dependent on knowledge workers, companies are beginning to see the value in soft skills.
Learn moreCourses
- Business Writing Skills
- Public Speaking
- Body Language
- Press Releases
- Customer Service Training
- Introduction to Sales
- Introduction to Marketing
- Communication Skills Basics
- Remote Work Communication Skills
- How to Prepare for a Job Interview
Resources
We want to help you succeed! Check out our resource center for help with your resume, job interviews, and your career. Let us help you put yourself ahead of the rest.
See resourcesDevelopment
Learning to code could be your ticket to a lucrative and fulfilling career. High salaries, the flexibility to work from anywhere, and a healthy job outlook are just three benefits you can look forward to in this dynamic industry.
Learn moreCourses
- Introduction to HTML
- Introduction to CSS
- Introduction to JavaScript
- Introduction to PHP
- Introduction to SQL
- Introduction to Python
- Introduction to Data Analysis with Python
- Django for Beginners
- Ruby on Rails for Web Development
- Intro to Ruby Programming
- Python with Excel
- + 1 more courses
Resources
Check out our resource center to find answers to common coding questions, interview tips, and step-by-step guides that will help you in your development career.
See resourcesDesign
If you want a job where you’ll be working on something different every day, thriving in a fast-paced environment and loving a creative challenge, a career in graphic design may be just for you.
Learn moreCourses
- Photoshop for Beginners
- Photoshop - Advanced
- Illustrator - Basic
- Illustrator - Advanced
Resources
Check out our resource guides to learn more about the graphic design tools that will help you to achieve your design dreams.
See resourcesData Analysis
Become a data analysis pro with our range of expert-led courses. Whether you are a data analytics novice or a numbers whiz, our on-demand courses will help advance your skills at a pace that suits you.
Learn moreCourses
- Introduction to SQL
- Power BI
- Introduction to Python
- Microsoft Excel - Power Query
- Microsoft Excel - Power Pivot
- Introduction to Data Analysis with Python
- Python with Excel
- Introduction to Tableau
Resources
From Python to Excel, or Power BI, Tableau and beyond, check out these free resources to help take your data analysis skills to the next level.
See resourcesSearch
- Search
- Log in
- Start free trial
- Go to dashboard
Microsoft Excel
7 minute read
The Excel RibbonAgnes Lo
Join the Excel conversation on Slack
Ask a question or join the conversation for all things Excel on our Slack channel.
Join Slack channel
What is the Excel ribbon?
The Excel ribbon refers to the tabs at the top of the Excel interface that helps users to navigate and locate the commands when using Excel.
Learn Excel for free
Start learning formulas, functions, and time-saving hacks today with this free course!
Start free courseThe Excel ribbon tabs
There are nine tabs on the Excel Ribbon: File, Home, Insert, Page Layout, Formulas, Data, Review, View, and Help. The Home tab is the default tab when Excel is opened.
1. File
This provides a backstage view of all the important commands related to the files — to create a new sheet, open a file, save the file, print the file, and export.
2. Home
This features the essential or most frequently used commands in Excel — formatting, font types, and filtering.
Similar features are organized by group, for example there is a Clipboard group with cut, copy, and paste commands; and a Font group with font styles, colors, and sizes.
Note that your ribbon options may appear differently depending on how big your screen is, and the size of your Excel window [as you make it smaller, you'll notice less buttons appear].
As there are a lot of features, we have divided it into two sections as pictured below, to give you a better look at all the buttons and groups.
3. Insert
This is where users can add various items to a spreadsheet, including Pivot Tables, pictures, shapes, charts, graphs, and symbols.
4. Page Layout
This allows users to customize the layout of the spreadsheet by adjusting the margins, color themes, gridlines, and print area. The changes are applicable when being printed as well.
5. Formulas
This is where all essential formulas are categorized under the function library and it provides various controlling options.
6. Data
This allows users to manage data in the current spreadsheet, within the file, and also to import external data from other sources.
7. Review
This is for users to perform various controlling functions, including spell check, translate, adding comments and notes, track changes, and to enable worksheet protection.
8. View
This provides options to alter the views of worksheets — gridlines, zoom, freeze panes, and to switch windows.
9. Help
This gives access to Microsoft support. It allows you to provide feedback and to suggest a feature to the community.
How to collapse and to restore the ribbon in Excel
By default, the ribbon is a “fixed” feature in Excel, meaning that it stays in the same place as we scroll down the page. However, when working on a large set of data in Excel, we might want to get extra space on the screen.
To do that, we can collapse the ribbon without having to zoom out or change the font size of the data or text.
How to collapse the ribbon in Excel
To collapse the ribbon in Excel:
- Right click anywhere on the ribbon.
- Then select the last option — Collapse the Ribbon.
How to restore the ribbon in Excel
You can restore the ribbon in exactly the same way we collapse the ribbon.
- Click on any command to access the ribbon.
- Right click anywhere and unselect Collapse the Ribbon.
Learn the best Excel shortcuts!
Download our printable shortcut cheatsheet for PC and Mac.
Enter your email address
How to customize the ribbon in Excel
As the Excel ribbon features most of the most frequently used commands, a customized ribbon helps ensure a smoother and faster user experience in Excel.
To customize the ribbon in Excel, just like collapsing the ribbon, right click anywhere on the ribbon and select Customize the Ribbon instead.
To add a command to a new tab
- Click New Tab. A new tab will be created under the Main Tabs section.
- Rename it if you wish by clicking Rename and then input the name. We’ve used “Goskills” in this example:
- Click OK.
- Select any command [e.g. Insert Picture] and add under the Group.
- Click OK at the bottom right to confirm the customization.
A new tab named GoSkills is now the one to the right of the Home tab. Under the tab, there’s a group with one command — Insert Picture.
To reset the Excel Ribbons
It’s equally important to reset and undo the customization as it is to customize. To reset:
- In Excel Options, select Reset All Customizations under Customizations.
- Click Yes and then OK at the right bottom.
Auto-hide ribbon and show tabs and commands
At the top left corner of the Excel window, there are shortcuts available for the display of the Excel ribbons.
- Select Auto-hide Ribbon to hide both tabs and commands.
- Select Show Tabs to show Ribbon tabs only.
- Select Show Tabs and Commands for the default view of both Ribbon tabs and commands readily available on display.
Ready to learn more Excel essentials?
Excel Ribbon tabs and commands are the most frequently used features in Excel.
They cover features from formatting, to layouts, creating graphs, and sorting and analyzing data. You can customize your ribbon to facilitate your work in Excel.
To learn more Excel essentials, try our free Excel in an Hour course today!
This beginner friendly course will teach you the basics of Excel and how to master essential functions and formulas in just one hour. ⌚
Learn Excel for free
Start learning formulas, functions, and time-saving hacks today with this free course!
Start free course
Loved this? Subscribe, and join 398,074 others.
Get our latest content before everyone else. Unsubscribe whenever.
Your email address
Join the Excel conversation on Slack
Ask a question or join the conversation for all things Excel on our Slack channel.
Join Slack channel
Agnes Lo
Agnes is a clienteling professional in luxury retail. She enjoys yoga and outdoor activities in her free time.
Facebook Twitter LinkedIn WhatsApp Pocket Email
Recommended
Excel Challenge 23
Take this Excel challenge! How do you rank the top 5 agents when duplicate scores exist?
Recommended
Pivot Table Filter in Excel
So you've entered all your data in Excel and you want to zero in on a special segment. Pivot Table filters help to display select portions of data at your discretion.
Recommended
Handling Lookups for Multiple Criteria in Excel
Learn how to lookup multiple criteria in Excel. Analyze the best options from the FILTER function to XLOOKUP.
GoSkills courses
- GoSkills Unlimited
- Microsoft Excel
- Microsoft Office
- Lean Six Sigma
- Finance
- Project Management
- Office Productivity
Company
- About us
- Careers
- Courses for teams
- Learning management system
- Accreditations & awards
- FAQ
- Terms & Privacy
Discover
- Resources
- Scholarship
- Gifts
- Reviews
- Redeem a code
- Verify a certificate
- Site map
Contact
USA/Canada: USA/CA: +1 650 822 7732
Email: info@goskills.com Media: media@goskills.com
Facebook Twitter LinkedIn Instagram
- Send us a message
About
GoSkills - Skills for career advancement
Advance your career with GoSkills! We help you learn essential business skills to reach your full potential. Learn effectively via bite-sized video tutorials taught by award-winning instructors.
Thank you for choosing to learn with us.
Newsletter
Your email address
Don’t miss out on our best deals! Sign up for our newsletter to get the latest news and specials delivered direct to your inbox.