Utilities

Solve for target values with Goal Seek and speed up routine sheet work with configurable formatting utilities and keyboard shortcuts.

Solve for target values with Goal Seek — specify a target cell, a desired result, and the input to adjust. Plus, trigger your most‑used formatting actions with a single keystroke and create multiple instances with custom settings.

Utilities support familiar Excel‑style shortcuts where applicable.

Perfect for analysts who use consistent formatting to indicate formulas, hardcodes, or links — all while staying inside Google Sheets.

Works inside Google Sheets.

Utilities

Goal Seek
Goal Seek
Solve formulas by automatically finding the input value that produces a desired result. Specify a target cell, a desired result, and the input cell to adjust. Advanced settings allow you to define calculation precision and optional lower and upper bounds for the variable. Designed for numerical stability and reliable convergence in complex models.
  • Alt + A + W + G
Apply & Cycle Formatting
Number Format Cycle
Quickly switches between general number formats.
  • Ctrl + Shift + 1
Percent Format Cycle
Toggles percent styles with one shortcut.
  • Ctrl + Shift + 2
Date Format Cycle
Cycles through common date formats.
  • Ctrl + Shift + 3
USD Currency Format Cycle
Applies and switches between USD currency formats.
  • Ctrl + Shift + 4
EUR & GBP Currency Cycle
Toggles between Euro and Pound formats.
  • Ctrl + Shift + 5
Logical Value Format Cycle
Formats TRUE/FALSE values in your preferred style.
  • Ctrl + Shift + 6
Font Color Cycle
Cycles between custom font colors.
  • Ctrl + `
Fill Color Cycle
Quickly applies or toggles between fill color presets.
  • Ctrl + Shift + K
Data Filtering
Data Filter
Toggles filters and opens the filter menu for the current column.
  • Ctrl + Shift + Ltoggle
  • Alt + Shift + Dmenu
Adjust Columns & Rows
Column Adjust
Auto‑fits column widths, or sets a specific width for selected columns.
  • Alt + H + O + Iauto‑fit
  • Alt + H + O + Wset width
Row Adjust
Auto‑fits row heights, or sets a specific height for selected rows.
  • Alt + H + O + Aauto‑fit
  • Alt + H + O + Hset height
Insert Columns & Rows
Column Insert
Insert a column to the left or right.
  • Alt + I + Cleft
  • Alt + I + Gright
Row Insert
Insert a row above or below.
  • Alt + I + Rabove
  • Alt + I + Bbelow
Merge & Unmerge
Merge / Unmerge
Merge All, Unmerge, Merge Horizontally, Merge Vertically.
  • Alt + H + M + Amerge all
  • Alt + H + M + Uunmerge
  • Alt + H + M + Hhorizontal
  • Alt + H + M + Vvertical
Freeze & Unfreeze
Freeze / Unfreeze
Freeze Row & Column, Unfreeze All, Freeze/Unfreeze Row, Freeze/Unfreeze Column.
  • Alt + W + F + Ffreeze row & column
  • Alt + W + F + Uunfreeze all
  • Alt + F + Rfreeze row
  • Alt + W + F + Runfreeze row
  • Alt + F + Cfreeze column
  • Alt + W + F + Cunfreeze column
Paste Special & Clipboard
Paste Special
Opens the Paste Special dialog. Also supports direct shortcuts to specific modes like values only, formats only, formulas only, transposed, column widths only, or everything except borders.
  • Alt + E + S
Copy Sum
Copies the sum of the selected range to the clipboard.
  • Ctrl + Shift + S
Decimal Places
Increase / Decrease Decimals
Increases or decreases decimal places.
  • Alt + H + 0increase
  • Alt + H + 9decrease
View
Toggle Grid Lines
Shows or hides gridlines for the current sheet.
  • Alt + G + F + G
Works inside Google Sheets.