Google Sheets Cheat Sheet

Here’s a cheat sheet for Google Sheets, covering various features and shortcuts:

Basics

  • Access Google Sheets:
  • Create a New Spreadsheet:
    • Click on “+ Blank” or go to “File” > “New” > “Spreadsheet.”
  • Rename the Spreadsheet:
    • Click on the spreadsheet name at the top.

Basic Operations:

  • Navigation:
    • Use arrow keys to navigate between cells.
    • Press Enter to move down or Tab to move right.
  • Inserting Data:
    • Type data directly into cells.
    • Use Ctrl + Enter to stay in the current cell after data entry.
  • Copying and Pasting:
    • Copy: Ctrl + C (Windows/Linux) or Command + C (Mac).
    • Paste: Ctrl + V (Windows/Linux) or Command + V (Mac).
  • Cut and Move:
    • Cut: Ctrl + X (Windows/Linux) or Command + X (Mac).
    • Move to destination cell and Paste: Ctrl + V (Windows/Linux) or Command + V (Mac).

Navigation and View Options

  • Switch Between Sheets:
    • Click on sheet tabs at the bottom.
  • Insert New Sheet:
    • Click on “+” at the bottom.
  • Freeze Rows/Columns:
    • Select row/column > “View” > “Freeze.”

Working with Sheets

  • Inserting Sheets:
    • Right-click on sheet tab -> Insert -> Sheet.
  • Renaming Sheets:
    • Right-click on sheet tab -> Rename.
  • Copying Sheets:
    • Right-click on sheet tab -> Copy to -> select destination.

Formatting

  • Format Painter:
    • Copy formatting from one cell and apply it to others.
  • Merge Cells:
    • Select cells > “Format” > “Merge cells.”
  • Text Alignment:
    • Use the alignment icons in the toolbar.

Formatting Cells

  • Text Formatting:
    • Bold: Ctrl + B (Windows/Linux) or Command + B (Mac).
    • Italic: Ctrl + I (Windows/Linux) or Command + I (Mac).
    • Underline: Ctrl + U (Windows/Linux) or Command + U (Mac).
  • Cell Alignment:
    • Left-align: Ctrl + Shift + L (Windows/Linux) or Command + Shift + L (Mac).
    • Center-align: Ctrl + Shift + E (Windows/Linux) or Command + Shift + E (Mac).
    • Right-align: Ctrl + Shift + R (Windows/Linux) or Command + Shift + R (Mac).
  • Formatting Numbers:
    • Increase decimal places: Ctrl + Shift + . (Windows/Linux) or Command + Shift + . (Mac).
    • Decrease decimal places: Ctrl + Shift + , (Windows/Linux) or Command + Shift + , (Mac).

Cell Editing

  • Data Validation:
    • Select cells > “Data” > “Data validation.”
  • Insert Comment:
    • Right-click on a cell > “Comment” or use “Insert” > “Comment.”

Formulas

  • Entering Formulas:
    • Start a cell with = to enter a formula.
  • Common Formulas:
    • SUM: =SUM(A1:A10)
    • AVERAGE: =AVERAGE(B1:B5)
    • COUNT: =COUNT(C1:C20)
  • Autofill:
    • Drag the small square in the bottom-right corner of the selected cell to autofill a series or formula.

Functions

  • SUM Function:
    • =SUM(range) to sum values in a range.
  • AVERAGE Function:
    • =AVERAGE(range) to calculate the average.
  • VLOOKUP Function:
    • =VLOOKUP(search_key, range, index, [is_sorted]) for vertical lookup.
  • ARRAYFORMULA:
    • Apply a formula to an entire column: =ARRAYFORMULA(A1:A10 * 2).
  • IF Function:
    • =IF(A1 > 10, "Yes", "No").

Charts and Graphs

  • Insert Chart:
    • Select data > “Insert” > “Chart.”
  • Chart Customization:
    • Click on the chart to access customization options.

Data Analysis

  • Sort Data:
    • Select range > “Data” > “Sort range.”
  • Filter Data:
    • Select range > “Data” > “Create a filter.”
  • Pivot Table:
    • Select data > “Data” > “Pivot table.”
  • Freezing Rows or Columns:
    • View -> Freeze -> select the number of rows or columns to freeze.

Collaboration

  • Share Spreadsheet:
    • Click on “Share” in the top right corner.
  • Comments and Discussion:
    • Right-click on a cell > “Comment” or use the “Comments” button.
  • Revision History:
    • “File” > “Version history” > “See version history.”

Shortcuts

  • Open Explore Pane:
    • Ctrl + Alt + Shift + I (Windows/Linux) or Cmd + Option + I (Mac).
  • Open Keyboard Shortcuts:
    • Ctrl + / (Windows/Linux) or Command + / (Mac).
  • Quick Navigation:
    • Ctrl + Backspace (Windows/Linux) or Command + Delete (Mac) to delete content in a cell.
  • Fill Down:
    • Ctrl + D (Windows/Linux) or Command + D (Mac).
  • Fill Right:
    • Ctrl + R (Windows/Linux) or Command + R (Mac).
  • Insert Row Above:
    • Ctrl + Shift + + (Windows/Linux) or Command + Shift + + (Mac).

Mobile App

  • Mobile App Navigation:
    • Use the app to access and edit spreadsheets on the go.
  • Voice Typing:
    • Tap the microphone icon on the keyboard.

Import and Export

  • Import Data:
    • File -> Import to import data from various sources.
  • Export Data:
    • File -> Download to export in different formats.

Additional Tips

  • Conditional Formatting:
    • Use “Format” > “Conditional formatting” for visual data highlighting.
  • Explore Add-ons:
    • Enhance functionality with Google Sheets add-ons.
  • Protect Sheets and Ranges:
    • Use “Data” > “Protect sheets and ranges” for security.

This cheat sheet covers various features and shortcuts in Google Sheets.