999 votes162 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
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!
Lead Program Manager
ExcelDick 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 ·