Tips and tricks for Cloud Sheets
Updated November 13, 2026
Entering data
- Same value in many cells: select them, type, and press Ctrl+Enter.
- Today’s date: Ctrl+;. The time: Ctrl+Shift+;.
- Fill a pattern from examples: type one or two, then Data › Flash fill (Ctrl+E).
- A table on paper: take a photo and use Data from Picture instead of typing it.
Moving and selecting
- Jump to the edge of your data: Ctrl+Arrow. Add Shift to select as you go.
- Go to the first cell: Ctrl+Home. The last used cell: Ctrl+End.
- Select a column or row: Ctrl+Space or Shift+Space.
- Go to any cell: type its address in the name box and press Enter.
Formulas
- Pick a suggested function with Tab as you type its name.
- Lock a reference with
$, such as$B$1, so it doesn’t move when you copy the formula. - One formula, many results: functions such as FILTER, SORT, UNIQUE and QUERY spill into the cells below.
- A trend in a cell:
=SPARKLINE(B2:M2). - Stuck on an error? Ask the assistant “why is D7 an error?”.
Lists and status
- Tick-off lists: Insert › Checkbox, then count ticks with
=COUNTIF(C:C,TRUE). - Coloured statuses: a Data › Validation list with Show as chips.
- Start ready-made: File › New… has seven templates.
Keeping work safe
- Save to MyCloudSuites to get File › Version History….
- Online, leaving is safe: unsaved changes are kept as a draft that Your apps lists.