Excel Forum

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

katerina Bsk

Active Member

Members

Forum Posts: 5

Member Since:
August 9, 2022

Offline

September 20, 2022 - 10:34 pm

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?

Jessica Stewart

Northern USA

Member

Members

Trusted Members

Forum Posts: 202

Member Since:
February 13, 2021

Offline

September 22, 2022 - 12:55 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.

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Jan pedersen, Francis Drouillard

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

wahab tunde

Cong Le Duc

Faisal Bashir

Ivica Cvetkovski

Blaine Cox

Shankar Srinivasan

riyepa fdgf

Hannah Cave

Len Matthews

Kristine Arthy

Forum Stats:

Groups: 3

Forums: 24

Topics: 6205

Posts: 27209

Member Stats:

Guest Posters: 49

Members: 31878

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen