I find it crucial for aspiring excel experts to know fully well the ribbons as these are the key to having better productivity in Excel.
Here is an overview of the most commonly useful ribbons available for excel.
Written instructions/guides for navigating ribbons usually goes like this:
Tab -> Group -> Ribbon button
so I will show each Tab, Group, and Ribbon associated to each other.
Pro Tip: If you want to hide these ribbons to show more vertical space on your spreadsheet, you can click the Collapse Ribbon button or you can simply use the shortcut ctrl F1.
Home Ribbon - This is where you find the most frequently used ribbons.
1 Clipboard
2 Font
3 Alignment
4 Number
5 Styles
6 Cells
7 Editing
Insert Ribbon -
1 Tables
2 Illustrations
3 Add-ins
4 Charts
5 Sparklines
6 Text
7 Symbols
Page Layout Ribbon -
1 Themes
2 Page Setup
3 Scale to Fit
4 Sheet Options
5 Arrange
Formulas Ribbon -
1 Function Library
2 Defined Names
3 Formula Auditing
4 Calculation
Data Ribbon -
1 Get & Transform Data
2 Queries & Connection
3 Sort & Filter
4 Data Tools
5 Forecast
6 Outline
7 Analyze
Review Ribbon -
1 Proofing
2 Comments
3 Protect
View Ribbon -
1 Workbook Views
2 Show
3 Zoom
4 Window
Developer Ribbon -
1 Code
2 Add-ins
3 Controls
4 XML
Help Ribbon -
Power Pivot -
Search Ribbon -
If you have at least 2016 version of excel, this is available for you.
Did you have all the Ribbon tabs shown?
You can modify the ribbon tabs being shown on your excel workbook by going to Excel Options.
Click the File tab -> Click Options -> Click Customize Ribbon
You should see this image below.
You can check out this article about Excel Options.
This post is designated as a reviewer for Basic Excel trainings I conduct.
Feel free to share with anyone. 😉
Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva.