Google Sheets Quick Tips

Get quick, bite-sized answers that tell you exactly what you want to know about working with Google Sheets.

Introduction

• Calculate data quickly with Google Sheets

1. Google Sheets Quick Tips

• Text wrap
• Add and reference sheets
• Change view options
• Freeze and lock panels
• Fill in a series of data
• Select specific rows or columns
• Move rows or columns
• Quickly insert multiple rows and columns
• Rotate cell data
• Copy cell formatting
• Create a named range
• Create and manage drop-down lists
• Merge cells
• Explore data
• Hide and unhide columns, rows, and sheets
• Protect an entire sheet
• Summing rows
• Adjust row height and column width
• Apply conditional formatting
• Insert a link into a cell
• Change sort order
• Align cells
• Filter views
• Download as Excel format
• Convert an Excel file to Sheets
• Rename and move a sheet
• Share a file
• View version history
• Undo unwanted changes
• Set alternating colors