Skip to content
Tutorials Center
My learning

Topics

Lesson 2 of 93 ยท Getting Started

A Tour of the Excel Interface

Find your way around Excel: the ribbon, Quick Access Toolbar, Name Box, formula bar, status bar, sheet tabs and views, plus the first shortcuts worth learning.

Excel's window looks crowded the first time you open it, but it is built from a handful of parts that you will use over and over. Once you know what each part is called and what it does, tutorials, help pages and colleagues become much easier to follow: "type it in the Name Box" or "check the status bar" will mean something.

This lesson is a guided tour in words. The real window cannot appear on this site, so we describe where each part lives and then use small JavaScript stand-ins for two parts that are really just logic: the Name Box (which understands cell and range addresses) and the status bar (which summarizes whatever you selected). Everything about the real window is described in plain text.

Top of the window

Quick Access Save, Undo and Redo in one click.
Ribbon Tabs of commands grouped by task.
Search box Type what you want to do.
1 / 3

The ribbon

The wide band across the top is the ribbon. It is organized in tabs, and each tab holds groups of related commands. The tabs you will use most:

Tab What it is for
Home Clipboard, font, alignment, number formats, styles, inserting and deleting cells, sorting and finding.
Insert Tables, PivotTables, charts, sparklines, pictures, shapes.
Page Layout Margins, orientation, print area, themes.
Formulas The function library, Name Manager, formula auditing, calculation options.
Data Importing data, sorting and filtering, data validation, Remove Duplicates, What-If tools.
Review Spelling, comments, protecting sheets and workbooks.
View Freeze panes, zoom, gridlines, switching windows.

Some tabs appear only when needed. Click a chart and Chart Design and Format tabs show up; click inside a table and Table Design appears. If you cannot find a command, look for these contextual tabs first.

You can collapse the ribbon to gain screen space with Ctrl+F1, and the Tell me / Search box near the top finds a command by name ("remove duplicates") and runs it directly. Many small buttons also have a dialog launcher, a tiny arrow in the group's corner that opens the full options window.

The File tab

The green File tab at the far left is different: it opens a full-screen area called backstage view for things that concern the whole workbook: New, Open, Save As, Print, Share, Export, Info (protection, version history) and Options (the settings window). You will use File โ†’ Options to change default fonts, calculation mode and the language.

The Quick Access Toolbar

The Quick Access Toolbar (QAT) is a small strip of buttons above or below the ribbon. By default it has Save, Undo and Redo. You can add any command to it with a right-click: right-click a button anywhere on the ribbon and choose Add to Quick Access Toolbar. Good candidates are Paste Values, Sort Aโ†’Z and Freeze Panes. An extra tip: the first nine QAT buttons get shortcuts Alt+1 through Alt+9.

The Name Box and the formula bar

Directly under the ribbon sit two small but important areas.

The Name Box on the left shows the address of the active cell (the one with the thick green border), for example C5. It is also an input field. Type Z100 and press Enter to jump there, or type B2:D10 to select that block of cells. Later you will give ranges friendly names (see Ranges and Named Ranges) and use the same box to jump to them.

The formula bar on the right shows the contents of the active cell. A cell that displays 42 might hold the number 42, the formula =6*7, or even text that looks like a number. The formula bar tells the truth. You can edit there too, which is handy for long formulas: the small arrow at its right end expands it to several lines, and Ctrl+Shift+U toggles the expansion. The ฦ’x button opens the Insert Function dialog.

How the Name Box understands addresses

Behind the scenes, the Name Box has to turn text like B2:D4 into a list of cells. This stand-in does that and prints what would be selected. It is a model of the idea, not Excel's code.

JS Name Box stand-in: parse an address or range

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Note that D10:B2 selects the same block as B2:D10, but the active cell is the first one you typed. Also XFD1048576 really is the last cell on a worksheet.

The grid, headers and sheet tabs

The large area in the middle is the grid. Gray column headers (letters) and row headers (numbers) run along its top and left edges. Click a header to select the whole column or row; right-click it to insert, delete, hide or resize. Double-click the line between two column headers to AutoFit the width to its longest entry.

At the bottom left are the sheet tabs, one per worksheet. Click a tab to switch sheets, double-click to rename, and press the + button to add a new one. The small arrows next to the tabs scroll through them when there are many. Details are in Workbooks, Worksheets and Navigation.

The status bar

The status bar is the thin strip at the very bottom. It shows the mode on its left side (Ready, Enter, Edit, Point) and, when you select several numeric cells, a quick summary in the middle: Average, Count and Sum. This is the quickest way to check a total without writing any formula: select the cells and glance down. Right-click the status bar to choose more items such as Minimum, Maximum and Numerical Count.

On the right are the view buttons (Normal, Page Layout, Page Break Preview) and the zoom slider. You can also hold Ctrl and scroll the mouse wheel to zoom.

What the status bar computes

The summary is a simple rule: it looks only at the numeric cells in your selection. Text is ignored for Sum and Average, but Count tells you how many non-empty cells you selected. This stand-in follows that rule.

JS Status bar stand-in: summarize a selection

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Excel hides Average and Sum when the selection has no numbers, which the stand-in copies. That is why you sometimes see only "Count" in the real status bar.

Views

The View tab and the buttons on the status bar switch between three views:

  • Normal: the everyday grid.
  • Page Layout: shows pages as they will print, with margins, headers and footers editable directly.
  • Page Break Preview: shows blue lines where pages will break, which you can drag.

Other View settings: tick or untick Gridlines, Headings and the Formula Bar; Freeze Panes keeps headings visible while you scroll; New Window opens a second window of the same workbook so you can compare two sheets side by side.

Shortcuts worth learning now

You do not need dozens. These ten pay off immediately (on a Mac, use Cmd for Ctrl):

Shortcut What it does
Ctrl+Z / Ctrl+Y Undo / Redo
Ctrl+C, Ctrl+X, Ctrl+V Copy, cut, paste
Ctrl+S Save
Ctrl+Arrow Jump to the edge of the data block
Ctrl+Home Jump to A1
Ctrl+A Select all (twice selects the whole sheet inside a table)
F2 Edit the active cell
F4 Repeat last action (and toggle $ in formulas, later)
Ctrl+; Insert today's date
Alt (tap) Show ribbon key tips for keyboard-only work

A longer list is in Keyboard Shortcuts and Productivity Tricks.

If you ever feel lost, press Ctrl+Z to undo, then click the Search box at the top and type what you were trying to do. Excel's undo history lasts for the session, so experimenting is safe, unless you have saved and closed the file.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Where would you look to see whether a cell contains a formula or a typed number?

    The formula bar shows the contents of the active cell. The cell itself shows only the displayed result.
  2. 2. What does typing B2:D10 into the Name Box and pressing Enter do?

    The Name Box jumps to an address or selects a range. It does not calculate anything.
  3. 3. You select five cells holding numbers and see Average, Count and Sum at the bottom of the window. Where is that?

    The status bar summarizes the selected numeric cells without any formula.
  4. 4. Which tab would you open to import data, sort, or add a dropdown list rule?

    The Data tab holds import tools, sorting and filtering, data validation, Remove Duplicates and What-If Analysis.

Summary

  • The ribbon has tabs and groups; contextual tabs appear when you select a chart or a table.
  • The File tab opens backstage view for saving, printing, sharing and options.
  • The Quick Access Toolbar keeps your favorite commands one click (or Alt+number) away.
  • The Name Box shows or jumps to an address; the formula bar shows what a cell really contains.
  • The status bar gives an instant Sum, Average and Count of a selection and holds the view and zoom controls.
  • Learn a handful of shortcuts first: undo, jump with Ctrl+Arrow, F2 to edit.

Next: Entering and Editing Data.