Google Sheets Tips

Cells and Text

• Add and use checkboxes
• Concatenate multiple values in the same cell
• Name a cell or a range of cells
• Reference a cell on another sheet

Dates and times

• Number of days, months, or years between two dates

Formatting

• Activate conditional formatting by checkbox
• Display duplicates using conditional formatting

Functions

• Create a named function
• Replace based on a table of values
• Use wildcard characters

Miscellaneous

• Generate a PDF of a cell range
• Round to 5 cents

Ranges and arrays

• Add a total line to a variable size table
• Filter a range if a column contains a value
• Flip a range horizontally
• Flip a range vertically
• Split text into columns
• Use braces

Sheets

• Freeze panes

More tips are available on the functions page...