Forum

Notifications
Clear all

Insert new row at end of locked Table, keeping formulas.

2 Posts
2 Users
0 Reactions
391 Views
(@katbsk)
Posts: 5
Active Member
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
(@jstewart)
Posts: 216
Estimable Member
 

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
Share: