Google Sheets How-Tos | Scribe

    Google Sheets How-Tos

      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. Click "File" then click "Make a copy"
      Rename what the copy will be named and then click "Make a copy."
      When prompted, click "Make a copy"

      Add a Link In the Table of Contents

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

      Link a Tab to a New Link

      Click on the cell you want to link.
      Click on the link icon.
      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.
      The color of the text will change by default to royal blue. To change the color of the text, highlight the text.
      Click on the [[Text color]] icon.
      Select the color.
      Was this Scribe helpful?
      Save this document for future reference.
      click-target-circles-background
      0 Selected
      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe