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
Apply & Cycle Formatting
Number Format Cycle
Quickly switches between general number formats. Default shortcut: Ctrl + Shift + 1.
Percent Format Cycle
Toggles percent styles with one shortcut. Default shortcut: Ctrl + Shift + 2.
Date Format Cycle
Cycles through common date formats. Default shortcut: Ctrl + Shift + 3.
USD Currency Format Cycle
Applies and switches between USD currency formats. Default shortcut: Ctrl + Shift + 4.
EUR & GBP Currency Cycle
Toggles between Euro and Pound formats. Default shortcut: Ctrl + Shift + 5.
Logical Value Format Cycle
Formats TRUE/FALSE values in your preferred style. Default shortcut: Ctrl + Shift + 6.
Font Color Cycle
Cycles between custom font colors. Default shortcut: Ctrl + `.
Fill Color Cycle
Quickly applies or toggles between fill color presets. Default shortcut: Ctrl + Shift + K.
Data Filtering
Data Filter
Toggles filters and opens the filter menu for the current column. Default shortcuts: Ctrl + Shift + L (toggle), Alt + Shift + D (menu).
Adjust Columns & Rows
Column Adjust
Auto‑fits column widths, or sets a specific width for selected columns. Default shortcuts: Alt + H + O + I (auto‑fit), Alt + H + O + W (set width).
Row Adjust
Auto‑fits row heights, or sets a specific height for selected rows. Default shortcuts: Alt + H + O + A (auto‑fit), Alt + H + O + H (set height).
Paste Special & Clipboard
Paste Special
Opens the Paste Special dialog. Default shortcut: Alt + E + S. Also supports direct shortcuts to specific modes like values only, formats only, formulas only, transposed, column widths only, or everything except borders.
Copy Sum
Copies the sum of the selected range to the clipboard. Default shortcut: Ctrl + Shift + S.
Decimal Places
Increase / Decrease Decimals
Increases or decreases decimal places. Default shortcuts: Alt + H + 0 (increase), Alt + H + 9 (decrease).
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. Default shortcut: Alt + A + W + G.
View
Toggle Grid Lines
Shows or hides gridlines for the current sheet. Default shortcut: Alt + G + F + G.
Works inside Google Sheets.