top of page

Sheets: Features, Tips, and Best Practices

Analyze and visualize data with powerful spreadsheets. Use formulas and charts to gain insights.

Sheets Resources

01

Google Sheets training and help

02

Get started with Sheets for Google Workspace

03

Switch from Excel to Sheets

04

Create project plans with Sheets

05

Tips to add & import data

06

Tips to format & clean up data

07

Tips to analyze data

Sheets Keyboard Shortcuts

Common Actions

Common actions	Keyboard shortcut
Select column	Ctrl + Space
Select row	Shift + Space
Insert a link	⌘/Ctrl + k
Insert new sheet	Shift + F11

Change Rows and Columns

Change rows and columns	Keyboard shortcut
Hide row	⌘/Ctrl + Alt + 9
Group rows or columns	Alt + Shift + Right arrow
Unhide row	⌘/Ctrl + Shift + 9
Ungroup rows or columns	Alt + Shift + Left arrow

Format Cells

Format Cells	Keyboard shortcut
Bold	⌘/Ctrl + b
Underline	⌘/Ctrl + u
Italic	⌘/Ctrl + i
Apply right border	Option + Shift + 4
Apply top border	Option + Shift + 1
Clear formatting	⌘/Ctrl + \
Center align	⌘/Ctrl + Shift + e
Right align	⌘/Ctrl + Shift + r
Left align	⌘/Ctrl + Shift + l
Apply left border	Option + Shift + 2
Apply bottom border	Option + Shift + 3

Add notes and comments

Add notes and comments	Keyboard shortcut
Insert/edit note	Shift + F2
Insert comment	⌘/Ctrl + Alt + m
Open discussion thread	⌘/Ctrl + Alt + Shift + a

bottom of page