Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel COLUMN Function
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • How to use Excel FORMULATEXT function
  • Vlookup Examples in Excel
  • How to get last row in text data in Excel

Data Analysis Examples

  • How to create dynamic reference table name in Excel
  • How To Filter Data in Excel
  • Move chart to a separate worksheet in Excel
  • How to calculate current stock or inventory in Excel
  • Add Outline to Data in Excel

Data Validation Examples

  • Excel Data validation specific characters only
  • Excel Data validation don’t exceed total
  • Excel Data validation no punctuation
  • Data validation must not exist in list
  • Excel Data validation only dates between

Excel Ribbon: Navigation, Customizing, Collapsing and All You Need To Know

by

How to Navigate through Excel Ribbon?

Excel Ribbon are directly below File, Home, Insert, Page layout, Formulas, Data, Review and View tabs.

Excel selects the ribbon’s Home tab when you open a workbook.

You can checkout our previous post on Working with Excel ribbon.

Customize Excel Ribbon

The essence of customizing the ribbon is mainly to add more command icons that are needed by the computer user.

Worked Example:   Add Developer Tab in Excel

Step 1. Right click anywhere on the ribbon, and then click Customize the Ribbon.

Step 2. Click New Tab.

Step 3. Add the commands you like.

Step 4. Rename the tab and group.

Worked Example:   Save file in 97-2003 Format

You can easily create your own tab and add commands to it.

you can also add new groups to existing tabs. To hide a tab, uncheck the corresponding check box. Click Reset, Reset all customizations, to delete all Ribbon and Quick Access Toolbar customizations.

Collapse the Ribbon

You can collapse the ribbon to get extra space on the screen.

Worked Example:   Customize Quick Access Toolbar in Excel

There are 3 Ways to Collapse Ribbon in Excel

  • Right click anywhere on the ribbon, and then click Collapse the Ribbon
  • Using Excel Shortcut — press CTRL + F1
  • Click the icon by the top most right as shown below:

Post navigation

Previous Post:

Working with and Understanding Excel Ribbon

Next Post:

How to perform a t-Test in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to display conditional message with REPT function in Excel
  • How to convert text string to array in Excel
  • Remove text by position in a cell in Excel
  • How to extract word containing specific text in Excel
  • How to extract multiple lines from a cell in Excel
  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate nth day of week in month in Excel
  • Get project end date in Excel
  • Get last working day in month in Excel
  • Add workdays to date custom weekends in Excel
  • Calculate interest for given period in Excel
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate principal for given period in Excel
  • COUPPCD function: Description, Usage, Syntax, Examples and Explanation
  • COUPNCD function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles