The Excel window and the Ribbon
Open the practice in the trainer →
All Excel commands live on the Ribbon — the wide strip under the title bar. The Ribbon is made of tabs, a tab of groups, and a group holds buttons, lists and check boxes. Below you will find a live copy of the window: everything described here can be clicked.
Parts of the window
| Title bar | the workbook name, the Quick Access Toolbar (Save, Undo, Redo — plus any commands you add) and the command Search box (Alt+Q) |
| Ribbon | tabs → groups → commands. The ↘ arrow in a group's corner opens the full dialog for that group, e.g. Format Cells |
| File tab | not a ribbon but the Backstage view: save, open, print, export, Options |
| Contextual tabs | appear only when an object is selected: Table Design, Chart Design, Picture Format |
| Name Box and formula bar | on the left the address of the active cell, on the right its contents: the formula, not the result |
| Sheet tabs | bottom left; "+" adds a sheet (Shift+F11) |
| Status bar | the mode (Ready, Enter, Edit) and, when several cells are selected, Average, Count, Sum without any formula. Right-click it to choose what to show. On the right — views and zoom |
What is on each tab
| Home | clipboard, font, alignment, number formats, conditional formatting, inserting and deleting rows, AutoSum, sorting, Find & Select |
| Insert | PivotTables, Tables, charts, sparklines, slicers, links, text boxes, symbols |
| Draw | pens and eraser for ink annotations |
| Page Layout | themes, margins, orientation, print area, print titles, scale to fit, viewing and printing gridlines |
| Formulas | function library, names, formula auditing, Show Formulas, calculation options |
| Data | Power Query, refresh, sort and filter, Text to Columns, Remove Duplicates, Data Validation, What-If Analysis, grouping |
| Review | spelling, comments and notes, sheet and workbook protection |
| View | workbook views, showing gridlines and the formula bar, zoom, Freeze Panes, windows, macros |
| Automate | Office Scripts |
| Developer | VBA, macro recording, form controls. Hidden by default — turned on in Options (lesson 3) |
Ribbon keys
| Alt | shows KeyTips — letters over the tabs; a letter opens a tab, the next ones run a command. You can work with no mouse at all: Alt, H, 1 — bold |
| Ctrl+F1 | collapse / expand the Ribbon |
| Ctrl+` | show formulas instead of values |
| Ctrl+1 | the Format Cells dialog |
Excel for Mac. The Ribbon tabs are the same (Home, Insert, Draw, Page Layout, Formulas, Data, Review, View, Automate), but there is no File tab: its commands are in the macOS menus (File, Excel). There are no Alt KeyTips. Collapse the Ribbon with ⌘+⌥+R, search commands with ⌘+⌃+U, Format Cells is ⌘+1.
Tasks in the Excel emulator
- Open the Formulas tab and click Show Formulas — the Amount column will show formulas.
- Open the Format Cells dialog with the ↘ button in the corner of the Number group on the Home tab.
- Select cells D2:D5 and read their sum in the status bar at the bottom.
- Click inside the window, press and release Alt, then press the letter of the View tab.
- Collapse the Ribbon to free up space.
- Add a new sheet to the workbook.
Solve the tasks in the trainer →
Check yourself
- Where do you open the full settings dialog of the Font group?
- You selected 10 cells with numbers. Where do you see their sum without a formula?
- The Table Design tab has disappeared. Why?