+ Reply to Thread
Results 1 to 2 of 2

How can I block "insert row" to everyone using the sheet?

  1. #1
    Registered User
    Join Date
    02-14-2020
    Location
    canada
    MS-Off Ver
    n/a
    Posts
    1

    How can I block "insert row" to everyone using the sheet?

    I have a public sheet that uses a lot of formatting and formulas to make things run, I'm running into an issue where people keep inserting rows instead of adding inputs in the specified place, I have tried big bold red DO NOT INSERT ROWS notifications but since it's a public sheet with anonymous users I seem to actually need a way to block that action completly.

    I am using google docs, so the protection options seem to be limited.

  2. #2
    Valued Forum Contributor hrlngrv's Avatar
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    373

    Re: How can I block "insert row" to everyone using the sheet?

    I figure you may need to ask this in Reddit's subreddit for Google Sheets, https://www.reddit.com/r/googlesheets/, or Google's own support site https://support.google.com/docs/community?hl=en.

    ADDED: To be more complete, Google Sheets provides a way to lock worksheets, but it's not the same as in Excel. You'd need to specify all the ranges in a worksheet which users could modify, then lock the worksheet. I haven't tried to do this in Google Sheets, but if its anything like Excel, protecting worksheets will disable some functionality such as sorting ranges, using filters, maybe other things.
    Last edited by hrlngrv; 02-15-2020 at 03:05 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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