Skip to content
Tutorials Center
My learning

Topics

Lesson 2 of 29 ยท Getting Started

A Tour of the Interface

Tour the Google Sheets screen: menus, toolbar, formula bar, name box, sheet tabs, zoom and frozen rows, with stand-ins for ranges and freezing.

When you open a spreadsheet, the screen looks crowded for a minute and then turns into a map you read without thinking. This lesson walks the map from top to bottom, so every later lesson can say "use the Name box" or "open the Data menu" and you know exactly where to look.

Menu names and positions change a little over time as Google updates the product, so the lesson names features by what they do. If a command has moved, the search box in the menus (the magnifier at the top, or Alt+/ on Windows and ChromeOS, Option+/ on Mac) finds it by name.

The screen itself is real Google Sheets and is described in words. The two TryIt blocks are stand-ins: small programs that copy the logic behind the Name box and frozen rows. They are not Google's code.

The screen from top to bottom

The top of the window

Title Click it to rename the file.
Menus File, Edit, View, Insert, Format, Data, Tools and more.
Toolbar Icons for undo, formats, fonts, borders, merge.
1 / 3

The menu bar holds every command. The ones you will use most:

  • File: share, make a copy, download (Excel, CSV, PDF), version history, settings (locale and time zone, which affect dates and number formats).
  • Edit: undo, redo, copy, paste special (values only, formatting only), find and replace.
  • View: freeze rows and columns, show formulas, hide gridlines, zoom.
  • Insert: rows, columns, charts, images, checkboxes, dropdowns, comments, new sheets.
  • Format: number formats, text styles, alignment, wrapping, conditional formatting.
  • Data: sort, filter, data validation, named ranges, pivot tables, remove duplicates.
  • Tools: spelling, notifications, Apps Script editor, accessibility options.

The toolbar

The toolbar repeats the most common commands as icons. From left to right you will find search, undo, redo and print, then zoom, then the number-format buttons (currency, percent, decimals), the format dropdown, font and font size, bold, italic, strikethrough and text color, fill color, borders, merge cells, alignment and wrapping, and finally links, comments, charts, filters and functions (the sigma button for quick sums). Hover over any icon to see its name and shortcut.

Name box and formula bar

The Name box at the top left always shows what you have selected: B2 for one cell, or something like A1:C3 for a block. It also works in reverse. Click it, type an address or a range, press Enter, and the selection jumps there. That is the fastest way to reach cell D4500, or to select a big block exactly. If you create a named range (see Relative, Absolute and Mixed References), you can type its name here instead.

The formula bar (marked fx) shows the actual content of the selected cell. A cell showing 1,250.00 might contain the number 1250, or the formula =B2*C2. Look in the formula bar when you want to know which. You can also edit there; press Enter to confirm or Escape to cancel.

The Name box understands a small language of its own. The stand-in below parses it and counts the cells in a selection.

JS Reading the Name box

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

No output.

Note that C3:A1 selects the same block as A1:C3; the order of the corners does not matter.

The grid

The grid is made of rows and columns, labelled by the headers on the top and left edge. Click a header to select a whole column or row, right-click for a menu to insert, delete, hide or resize it, and drag the border between two headers to change a size. Double-click the border to fit the content. Click the gray square at the top left corner to select everything.

Useful ways to move and select:

  • Arrow keys move one cell; Ctrl+Arrow (Cmd+Arrow on Mac) jumps to the edge of the data block.
  • Shift+Arrow extends the selection, and Ctrl+A selects all.
  • Click one cell and Shift+click another to select the range between them.
  • Ctrl+click adds separate cells or ranges to the selection.
  • The small blue square at the bottom right of a selection is the fill handle, covered in Entering and Editing Data.

When you select several numeric cells, the bottom right of the window shows quick statistics such as sum and average without writing a formula. Use the Explore panel (bottom right) or the Functions button for more.

Sheet tabs

At the bottom left, the plus button adds a sheet and the list button shows all sheets, including hidden ones. Right-click a tab to rename, change color, duplicate, copy to another spreadsheet, hide, move or delete. Double-click to rename quickly.

Zoom, gridlines and freezing

For zoom, use the toolbar zoom box or Ctrl with the mouse wheel in some browsers. Browser zoom changes the size of the whole page, while the zoom control in Sheets changes only the grid.

Long tables have a problem: when you scroll down, the column titles scroll away. Freezing fixes the top rows or left columns in place. Choose View > Freeze and pick one row, two rows, or "up to current row" with the selection. You can also drag the thick gray bar in the top left corner of the grid. A thicker line shows the frozen border. Freeze a row of titles in any table longer than a screenful, and freeze an ID column when the table is very wide.

Freezing only changes what you see. It does not change the data, sorting or printing. The stand-in below shows which rows are visible at each scroll position.

JS What does freezing do?

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

No output.

With the header frozen, it stays in view no matter how far you scroll.

Other helpful features

  • Show formulas: Ctrl plus the backtick key toggles every cell between result and formula, handy for checking a sheet.
  • Hide gridlines under View > Show > Gridlines for a cleaner look.
  • Protected view and sharing banners tell you when you only have view access.
  • Keyboard shortcut list: press Ctrl+/ to open it. The Google Sheets Cheat Sheet collects the best ones.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What is the Name box for?

    The Name box shows the current selection, and typing an address or named range there selects it.
  2. 2. A cell shows 1,250.00. Where do you look to see whether it holds a formula?

    The formula bar shows the real content of the selected cell, while the cell shows the formatted result.
  3. 3. What does freezing the first row do?

    Freezing is a view setting. The row stays in place on screen, but the data and permissions do not change.
  4. 4. Which range covers the same cells as C3:A1?

    The two corners define the block, in either order, so C3:A1 is the block A1:C3.

Summary

  • The top of the window has the title, menus and toolbar; above the grid sit the Name box and the formula bar.
  • The Name box shows and sets the selection; the formula bar shows what a cell really contains.
  • Sheet tabs at the bottom switch, add, rename, color and move sheets.
  • Freeze rows or columns so titles stay visible while you scroll; it only changes the view.
  • Menu names can change, so use the menu search to find a command.

Next: Entering and Editing Data