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.

Was this article helpful?