Skip to main content
Chemistry LibreTexts

1: Google Sheets Basics

  • Page ID
    304296
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    Navigating Google Sheets

    google sheet menu, row (horizontal), column(vertical), and cell labeled
    Figure \(\PageIndex{1}\): Parts of a Google Sheet labeled (Poirot)

    Make a Google Sheet

    First thing we will be doing is making a google sheet. There's multiple ways to access sheets but we will start with the way that is easiest to keep organized.

    Video \(\PageIndex{1}\): 0:11 video on making a Google Sheet in Drive. (https://youtu.be/TAYVbgreE8s)

    Step 1. Open your google drive

    Step 2. Click +New in the top left corner which will open a drop down menu

    Step 3. Select Google Sheets which will open your sheet in a new tab

    Copy a Google Sheet

    Making a copy of a sheet is a very useful tool. You can use previous sheets as a template for new data or to have an original copy to save when sharing a sheet.

    Video \(\PageIndex{2}\): 0:38 video on copying and naming a Google Sheet (https://youtu.be/MIPYCvl9-Fw)

    1. Open the sheet you want to make a copy of
    2. In the menu, click File and then Make a copy.
    3. This will open the box where you can name your new sheet. (For students I recommend including your name in the title to help whoever is grading your sheet stay organized)
    4. Use folder to select where to save your new copy
    5. Click on OK to make your copy which will open in a new tab

    Google Sheets: Tabs

    Tabs (Sheets) are a great way to organize data within one spreadsheet.

    clipboard_e6168efb7df9deb568f4bd1a54ef80e36.png

    Figure \(\PageIndex{2}\): Sheets and New Sheet

     

    Video \(\PageIndex{3}\): 2:48 Video tutorial on tabs. (https://youtu.be/WTUd8rZ2WHE)

    Make new Tab (Sheet) in Spreadsheet

    TimeStamp: Video 3 0:08

    1.  Click the plus button on the bottom left corner of the screen
    2. Right click and select Rename

    It is best practice to name sheets as all one word. This will make things a lot easier later on when referencing sheets later on. You can use and underscore (_) to replace a space.

    Duplicate a Tab

    TimeStamp: Video 3 0:37

    1. Right click on the tab you wish to make a copy of
    2. Select Duplicate to make a copy
    3. Right Click the new tab and select Rename

    Organizing Tabs

    To move a tab click on the tab and drag it to rearrange. TimeStamp: Video 3: 1:03

    To hide a sheet Right click on the tab then select Hide Sheet. This will hide the sheet from view. TimeStamp: Video 3: 1:15

    To unhide a sheet go to the menu and select View. Go down to Hidden Sheets to select the sheet you want to unhide. TimeStamp: Video 3: 1:23

    To protect a sheet (meaning choosing who can edit a tab) Right click on the tab then select Protect sheet. This will open a menu to the right, click Set Permissions to choose who can edit this sheet then press done. TimeStamp: Video 3: 1:33

    You can combine Protect sheet and Hide sheet to prevent anyone from being able to open a sheet TimeStamp: Video 3: 2:15

     

    Robert E. Belford (University of Arkansas Little Rock; Department of Chemistry). The breadth, depth and veracity of this work is the responsibility of Robert E. Belford, rebelford@ualr.edu. You should contact him if you have any concerns. This material has both original contributions, and content built upon prior contributions of the LibreTexts Community and other resources, including but not limited to:

    • Liliane Poirot

    1: Google Sheets Basics is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?