How to use Google Sheet: The Complete Beginner’s Guide

What is Google Sheets?

How to get started with Google Sheets?

How to create a spreadsheet?

  1. Click the red “NEW” button on your Google Drive dashboard and select “Google Sheets”
  2. Open the menu from within a spreadsheet and select “File > New Spreadsheet”
  3. Click “Blank” or select a template on the Google Sheets homepage

How to add data to the spreadsheet?

  1. Click a cell that’s empty, or double-click a cell that isn’t empty.
  2. Start typing.
  1. Copy and paste a list of text or numbers into your spreadsheet
  2. Copy and paste an HTML table from a website
  3. Import an existing spreadsheet in csv, xls, xlsx and other formats

How to import a file to Google Sheets?

How to Format Data and use other functions?

How to do basic formatting with rows and columns?

  • Click on the existing column or row next to where you’d like to insert a new column or row.
  • Right-click and the options menu will appear
  • Select Insert Before (or Insert After) for Columns, or Insert Above (or Insert Below) for Rows:
  • Click the cell where you want to add an image.
  • Click Insert > Image.
  • Select to place your image in the cell or over the cells. Cells with an image cannot also have text.
  • Choose an image or take a snapshot.
  • Click Open or Select.

How to use Data and basic formulas in Google Sheets?

  • Plain text format
  • Number format
  • Date format
  • Currency
  • Duration and more

How to Add, Average, and Filter Data with Formulas?

How to call a function in Google Sheets?

How can you share your Data?

  • Click either FILE > SHARE or use the blue “Share” button in the top right
  • Click “advanced”, then enter emails of who can view or edit your spreadsheet
  • Select any other privacy options and hit done
  • View-only access, so that person can not change or comment on any data
  • Comment-only access, so that person can add comments but still not make any changes to the data in the Sheet
  • Editing access, so that person can make changes to the sheet (including comments)

Comments (and Notes)

Real-time Sheets using

How to Use Your Spreadsheet in Offline Mode?

  • Google Chrome
  • Google Drive Chrome Web App
  • Google Drive Sync

What is conditional formatting and how you can do that with Google sheets?

How to Sort data in Google Sheets?

How to Filter data in Google Sheets?



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store