+ Reply to Thread
Results 1 to 2 of 2

Hide formulas in Google sheets?

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2013

    Hide formulas in Google sheets?

    I have tried ti find this info but not really sucessfully.

    Does anyone know if its possible to share a google spreadsheet to someone else and hide the formulas for that user? If so, how?
    Also is it possible to share with 1 person, but limit that person from sharing the google sheet to other people?

  2. #2
    Registered User
    Join Date
    Worcester, United Kingdom
    MS-Off Ver
    Office Pro 2013 (Work), Office 365 (Home)

    Re: Hide formulas in Google sheets?

    Hi Stockman,

    I do not know about the first part of your query however in relation to the second part aka limitation, when you click "Share" you will see a little pencil icon to the right, you can click then and see three options:

    Can edit
    Can Comment
    Can View

    I think if you set it to "Can View" (basically read-only) I don't believe they can share the document only view it.

    I'm on a work PC so cannot really test it but in theory that is what makes sense to me.

    Hope it helps! God speed!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to hide and show certain rows by a click in google sheets
    By ElPedro in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-06-2017, 11:34 PM
  2. [SOLVED] Invisible hide the formulas from all sheets in workbook based on Green color
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-19-2017, 12:57 PM
  3. Filtered View With Formulas - GOOGLE SHEETS
    By Vilac7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2017, 12:09 AM
  4. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  5. Replies: 3
    Last Post: 11-09-2014, 11:09 AM
  6. Replies: 1
    Last Post: 01-25-2014, 02:10 PM
  7. Replies: 3
    Last Post: 10-23-2012, 06:09 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1