Skip to main content

Customize sheet view

You can adjust the workspace zoom and the appearance of the range field and formula bar.

Quickly change the zoom level​

To quickly change the zoom, use the tools at the bottom of the window and on the View tab:

Zoom in (Ctrl+= or Cmd+=).

Zoom out (Ctrl+- or Cmd+-).

You can also:

  • Set the zoom to 100% by pressing Ctrl+0 (Cmd+0).
  • Change the zoom by dragging the round marker ● along the scale.

Select a preset zoom level​

  1. Click on the arrow to the right of the current zoom value.
  2. Select the desired zoom percentage from the menu.

Set a precise zoom value​

  1. Click the field with the current zoom value.
  2. Enter a new percentage value.
  3. Press Enter.

Expand or narrow the range field​

  1. Hover the cursor over the right edge of the field. The cursor will change to a vertical double-headed arrow .
  2. Hold down the left mouse button and drag the border right or left.

Resize the formula bar​

  1. Hover the cursor over the bottom border of the formula bar. The cursor will change to a vertical double-headed arrow .
  2. Hold down the left mouse button and drag the border up or down.

Expand or collapse the formula bar​

  1. Hover the cursor over the expand or collapse arrow on on its right side.
  2. Click the left mouse button.

You can also use the Expand formula bar or Collapse formula bar tools on the View tab, in the Formula bar menu.

Fit the formula bar to data​

  1. Hover the cursor over the Fit to data button on the right side of the bar.
  2. Click the left mouse button.

You can also use the Fit formula bar to data tool on the View tab, in the Formula bar menu.