Sheet Studio
Ultimate
Search tools & commands
Ctrl K
Home
Insert
Data
View
Formulas
Tools
Clipboard
Quick tools
Inter
Segoe UI
Arial
Calibri
Georgia
Courier New
9
10
11
12
14
16
18
20
24
32
40
Font
Alignment
General
Number
Currency
Percent
Date
Number
Cells
Controls
Visual
Structure
Sort
Clean
Analyze
Formula
Sheet view
Zoom
Workspace
Formula tools
Calculation
Quick functions
Transform
Smart cells
Workbook
fx
Find & replace
Search values and formulas in the current sheet.
Match case
Conditional formatting
Highlight cells in
A1
when a rule is true.
Greater than
Less than
Text contains
Duplicate value
Green highlight
Red highlight
Amber highlight
Blue highlight
Preview
Version checkpoints
Create local restore points before a big edit or import.
Keyboard shortcuts
Fast spreadsheet navigation and editing.
Command palette
Ctrl K
Find & replace
Ctrl H
Find next
Ctrl F
Fill down
Ctrl D
Fill right
Ctrl R
Undo / redo
Ctrl Z / Y
Copy / paste
Ctrl C / V
Open / import
Ctrl O
Export
Ctrl Shift E
Focus mode
Ctrl Shift F
Export workbook
Keep the workbook editable or publish the current sheet in a simpler format.
New workbook
Start blank or use a useful starter layout.
Dropdown validation
Apply a list of allowed values to the current selection.
Import spreadsheet
Open Excel, CSV, TSV, JSON project, or an HTML table.
Drop a spreadsheet here
or click to choose a file
Formula guide
Common formulas supported directly by Sheet Studio.
SUM
=SUM(B2:B12)
AVERAGE
=AVERAGE(C2:C8)
MIN / MAX
=MAX(D2:D20)
COUNT / COUNTA
=COUNTA(A2:A50)
ROUND / ABS
=ROUND(B2,2)
IF
=IF(C2>100,"High","Low")
AND / OR
=AND(B2>0,C2<10)
CONCAT
=CONCAT(A2," ",B2)
UPPER / LOWER / LEN
=UPPER(A2)
Pivot summary
Group rows by one field and summarize another field into a new sheet.
Sum
Count
Average
Min
Max
Named ranges
Give important cells and ranges memorable names and use them in formulas.
Goal Seek
Find an input value that makes a formula cell reach a target result.
Selection insights
Profile the current range.
Insert sparkline
Create a tiny chart inside the active cell.
Line
Bars
Hyperlink
Turn the active cell into a clickable web link.
Paste special
Choose exactly what to paste from the most recent copied range.
⧉
Everything
Values, formulas and formatting
123
Values only
Paste displayed results without styles
Aa
Formatting only
Keep destination values
↔
Transpose
Swap rows and columns
Workbook navigator
Jump between sheets and see their used ranges at a glance.
Function library
Click a function to insert a starter formula into the active cell.