Select cells to see statistics.
Start formulas with =
=SUM(A1:A10) — Sum range
=AVERAGE(B1:B5) — Average
=IF(A1>0,"Yes","No") — Conditional
=VLOOKUP(val,range,col) — Lookup
=COUNTIF(A:A,">5") — Count if
=CONCATENATE(A1,B1) — Join text
=TODAY() — Today's date
=IFERROR(expr,val) — Error handle
Ctrl+C/V/X — Copy/Paste/Cut
Ctrl+Z/Y — Undo/Redo
Ctrl+F — Find
Ctrl+H — Replace
Ctrl+B/I/U — Bold/Italic/Underline
F2 — Edit cell
Delete — Clear cell
Tab — Move right
Enter — Move down
Shift+Enter — Move up
Ctrl+Home/End — Go to start/end
Ctrl+Arrow — Jump to edge
🖱️ Drag fill handle (bottom-right corner) to auto-fill series.
📌 Right-click for context menu options.
📐 Drag column headers to resize.
Set rules to restrict what can be entered in the selected cell range.
Charts are built from your selected range data and rendered inline.
Filter hides rows that don't match your criteria. First row of range is treated as header.
Finds the input that makes a formula reach a target. Formula must reference the changing cell.
Name a range, use it in formulas. E.g. name B2:B20 as "Sales", write =SUM(Sales).
Lock cells first (Tools→Lock), then protect. Unlocked cells remain editable.
Pattern detected. Review then click Apply.
Proportional bar inside each cell based on its value.
Click any style to apply to selected cells.