Feedback by UserVoice

Dick Kusleika

My feedback

  1. 999 votes
    Sign in
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!


    Ashvini Sharma
    Lead Program Manager

    Dick Kusleika commented  · 

    Here's how I'd set it up: Four check boxes that are specific to tables.

    1. Allow new record (only allows adding a new record to the bottom of the table, default checked)
    2. Allow insert/remove record (can add or delete rows anywhere)
    3. Allow editing non-formula cells (default checked)
    4. Allow editing formula cells

    When you protect a sheet, and don't change any defaults, tables will be locked down except that you can modify existing rows and add a new one at the bottom. Then, if you prefer, you can allow the other two.

    Table permissions would always override non-table permissions. That is, whatever the state of the cells below or to the right of the table, they can get overwritten by adding rows or columns. Also, you can always add/remove header row and total row.

    If you want to do stuff like add or move columns, you have to unprotect the sheet.

    Dick Kusleika supported this idea  · 

Feedback and Knowledge Base