Ribbon in MS Excel
In Microsoft Office 2007, Microsoft introduced “Familiar User Interface” or “Familiar UI”, that replaced the traditional Menu bars and adjustable toolbars with a solitary “Office menu”, a smaller than usual toolbar known as “Quick Access Bar” and a Ribbon bar having multiple tabs. Every tab holds a toolbar bearing buttons for various operations. Toolbar controls have heterogeneous sizes and are grouped in a significant manner.
By default, the Ribbon contains 8 tabs in MS Excel 2013
Minimizing and Maximizing the Ribbon
By default, Ribbon is set to be fixed, however, it can be minimized or maximized by using the following methods.
Minimizing the Ribbon
You can click the “^” symbol on bottom-right corner of the ribbon.
Right click on the ribbon, and click on “Collapse the Ribbon”.
The fastest way to minimize the ribbon is by pressing a shortcut key “Ctrl + F1”.
Maximizing the Ribbon
Right click on the ribbon, and un-tick the “Collapse the Ribbon” option.
The fastest way to pin the ribbon is by pressing the shortcut key “Ctrl + F1”.
Customizing the Ribbon
To customize the ribbon, right click on the Ribbon and click on “Customize the Ribbon” options
This will option the ribbon customization window
In this example, a new tab has been added.
And it is renamed as DEMO TAB
Now this tab is visible next to File Menu
Multiple handy options like All Charts type, Cut, Font Color and Format Cells have been added for demonstration purpose.
More Related Articles For You
- Important Terminologies in Microsoft Excel
- Working with Rows, Columns and Cells in Excel
- Working with Ranges in MS Excel
- Formulas and Functions in MS Excel
- Workbook in MS Excel
- Formatting Cells in MS Excel
- Templates in MS Excel
- Data Validation in MS Excel
- Excel Keyboard Shortcuts
- Protecting a Workbook in MS Excel with Password
- Print Gridlines in an Excel Worksheet
- How to Share MS Excel Data
- Count and Sum Function in Excel
- Logical Functions in Excel
- Date and Time Function in Excel
- Worksheet in Excel
- Find and Select in Excel
- Cell References in Excel