Google Sheets How-Tos | Scribe

    Google Sheets How-Tos

      alert ordinal icon
      Alert! This workbook is compatible with MS Excel. However, some formatting is not, primarily with the [[Checkboxes]]. Use the file provided at the time of purchase for the Excel version with compatible formatting. Feel free to download this Google Sheets workbook and edit the formatting to your preferences as an option.

      Make a Copy

      1
      1. Click "File" then click "Make a copy"
      1. Click "File" then click "Make a copy"
      2
      Rename what the copy will be named and then click "Make a copy."
      3
      When prompted, click "Make a copy"

      Add a Link In the Table of Contents

      4
      On the cell to be linked.
      5
      Click on the link icon button.
      6
      Type in your link. In this example, "[www.addyourownlink.com](http://www.addyourownlink.com) is used. Then hit [[enter]]"
      7
      The color of the text will change by default to royal blue. To change the color of the text, highlight the text.
      8
      Click on the font editing button.
      9
      Select the desired color.
      10
      Color of link will be changed.

      Link a Tab to a New Link

      11
      Click on the cell you want to link.
      12
      Click on the link icon.
      13
      Begin to type the tab you want to link to, and it will show up in a dropdown list. In this example, the "Workbook Instructions" tab was used.
      14
      The color of the text will change by default to royal blue. To change the color of the text, highlight the text.
      15
      Click on the [[Text color]] icon.
      16
      Select the color.