"Excel 2010 Ribbon: Overview and How to Hide the Ribbon?"
The Excel 2010 Ribbon is great! This is because it allows to access all of the program's features and commands. The Ribbon is the horizontal strip that runs across the top of the Excel2010 window, just below the title bar.
- Clicking the down arrow in the upper right hand corner of the application (near the question mark) will open or close the ribbon interface (as shown below).
- You can also use the keyboard shortcut Ctrl + F1 to minimize or expand the ribbon.
- Click the arrow again will expand the ribbon.
The Ribbon is organized into various tabs, such as File, Home, Insert, etc and each tab contains related controls, which usually include buttons, lists, and check boxes. Not like Excel 2003, there is no menu bar in Excel 2010, so you do not use pull-down menus to access commands.
To help you better understand the ribbon, here are the tabs as it common functions:
- File: This tab replaces the Office Button in Excel 2007. Use this tab to do things such as opening, saving, printing files and so on.
- Home: Use this tab when creating, formatting, and editing a spreadsheet.
- Insert: Use this tab when adding particular elements (including graphics, table, PivotTables, charts, hyperlinks, headers and footers, etc) to a spreadsheet.
- Page Layout: Use this tab when preparing a spreadsheet for printing or reordering graphics on the sheet (including changing theme, setting margins, graphic orientations, etc).
- Formulas: Use this tab when adding formulas and functions to a spreadsheet or checking a worksheet for formula errors.
- Data: Use this tab when importing, querying, outlining, and subtotaling the data placed into a worksheet's data list.
- Review: Use this tab when proofing, protecting, and marking up a spreadsheet for review by others.
- View: Use this tab when changing the display of the Worksheet area and the data it contains.
In Office 2010 the ribbon can be hidden way with one simple mouse click. This function is available to the entire office suite include Word, Outlook, PowerPoint, and Excel.
Show Ribbon:
Minimize Ribbon:





