Course contents · Excel interface and options

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 barthe workbook name, the Quick Access Toolbar (Save, Undo, Redo — plus any commands you add) and the command Search box (Alt+Q)
Ribbontabs → groups → commands. The ↘ arrow in a group's corner opens the full dialog for that group, e.g. Format Cells
File tabnot a ribbon but the Backstage view: save, open, print, export, Options
Contextual tabsappear only when an object is selected: Table Design, Chart Design, Picture Format
Name Box and formula baron the left the address of the active cell, on the right its contents: the formula, not the result
Sheet tabsbottom left; "+" adds a sheet (Shift+F11)
Status barthe 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

Homeclipboard, font, alignment, number formats, conditional formatting, inserting and deleting rows, AutoSum, sorting, Find & Select
InsertPivotTables, Tables, charts, sparklines, slicers, links, text boxes, symbols
Drawpens and eraser for ink annotations
Page Layoutthemes, margins, orientation, print area, print titles, scale to fit, viewing and printing gridlines
Formulasfunction library, names, formula auditing, Show Formulas, calculation options
DataPower Query, refresh, sort and filter, Text to Columns, Remove Duplicates, Data Validation, What-If Analysis, grouping
Reviewspelling, comments and notes, sheet and workbook protection
Viewworkbook views, showing gridlines and the formula bar, zoom, Freeze Panes, windows, macros
AutomateOffice Scripts
DeveloperVBA, macro recording, form controls. Hidden by default — turned on in Options (lesson 3)

Ribbon keys

Altshows 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+F1collapse / expand the Ribbon
Ctrl+`show formulas instead of values
Ctrl+1the 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

  1. Open the Formulas tab and click Show Formulas — the Amount column will show formulas.
  2. Open the Format Cells dialog with the ↘ button in the corner of the Number group on the Home tab.
  3. Select cells D2:D5 and read their sum in the status bar at the bottom.
  4. Click inside the window, press and release Alt, then press the letter of the View tab.
  5. Collapse the Ribbon to free up space.
  6. Add a new sheet to the workbook.

Solve the tasks in the trainer →

Check yourself

  1. Where do you open the full settings dialog of the Font group?
  2. You selected 10 cells with numbers. Where do you see their sum without a formula?
  3. The Table Design tab has disappeared. Why?