Google Sheets Guides

With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically. Use the guides below to learn Sheets and refer to their cheat sheet

Overview

Section 1: Create or import files

• 1.1 Create a new file
• 1.2 Import and convert existing files

Section 2: Add content to your spreadsheet

• 2.1 Enter and edit your data
• 2.2 Customize your spreadsheet
• 2.3 Work with rows, columns, and cells
• 2.4 Work with multiple sheets

Section 3: Share and collaborate on files

• 3.1 Share files in Drive, Docs, Sheets, or Slides
• 3.2 Unshare files in Drive, Docs, Sheets, or Slides
• 3.3 Add comments and replies in Drive, Docs, Sheets, or Slides
• 3.4 Suggest edits in Docs 3.5 Chat with people directly in Docs, Sheets, or Slides

Section 4: Print and download files

• 4.1 Print your file
• 4.2 Download versions in other formats
• 4.3 Make a copy
• 4.4 Email a copy as an attachment

Section 5: Access your calendar, notes, and tasks

• 5.1 Open your Google Calendar and events
• 5.2 Open notes in Google Keep
• 5.3 Open your to-do lists in Google Tasks
• 5.4 Get add-ons

More on Google Sheets

Section 1: Access Sheets

• 1.1 Get Sheets on your devices
• 1.2 (Optional) Add multiple Google Accounts
• 1.3 Create a browser bookmark
• 1.4 Add a Sheets desktop shortcut (Windows only)
• 1.5 Work offline (Chrome only)

Section 2: Sheets and Excel best practices

• 2.1 Work with Excel files in Drive
• 2.2 Use Excel and Sheets together
• 2.3 Edit Excel files in Sheets
• 2.4 Import Excel data into Sheets
• 2.5 Convert Excel files to Sheets
• 2.6 Share a copy of a Sheets file in Excel format

Section 3: Manage data in Sheets

• 3.1 Perform basic operations
• 3.2 Search for data
• 3.3 See changes to data
• 3.4 Restrict data sharing
• 3.5 Use keyboard shortcuts

Section 4: Analyze data in Sheets

• 4.1 Add charts
• 4.2 Get automatic charts
• 4.3 Add charts to Docs and Slides
• 4.4 Functions in Sheets and Excel
• 4.5 Add pivot tables
• 4.6 Get automatic pivot tables

Section 7: Export spreadsheets

• 7.1 Print spreadsheets
• 7.2 Download in different formats
• 7.3 Make a copy
• 7.4 Email a copy

Section 8: Get Sheets productivity tips

• 8.1 Import data from Forms
• 8.2 Save time with templates
• 8.3 Find out if someone changes a spreadsheet