Dick Kusleika

My feedback

  1. 253 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      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