Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
391
Views
Topic starter
I have a Table and in some columns I am using formulas.
I want to lock these columns to avoid users' entries. But if locked the users cannot add a new row (I do not want Macros). And the new row must be at the bottom of the table.
So I want users to be able to add new row at the bottom of the table, with the formulas auto-dragging down, without the users to be able to write in formula cells.
Is that possible?
Posted : 21/09/2022 8:34 am
When you lock your worksheet there is a list that pops up, find Insert Rows and check it (If there is anything else you want to allow while the sheet is locked check the box next to the action), then lock your worksheet as normal. Should be what you are looking for.
Posted : 22/09/2022 10:55 am