New cells added to a protected sheet will not lock
Our take
I created a worksheet that required me to lock certain cells. The worksheet needed editing so I removed the protection so I could add additional columns. One of the two columns needs to be protected, while the other needs to be unlocked for data input. I made the unlocked range in the mange protection window and resumed protection on the worksheet but all new columns remained unlocked. All original cells on the worksheet (before the new colums) still lock and those that were put in an unlocked range remain unlocked.
I am predominately working in the browser mode. I have used the desktop app to make sure all cells are locked in the fromat cells > protection settings.
In the Manage Protection settings under options "Select locked celld" and "Select unlocked cells" are checked, everything else is unchecked.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Inserting new, whilst copying adjacent protected formulasDisclaimer! My Excel knowledge is intermediate at best! I’ve made a large workbook that my company wants me to share with colleagues as a standardised template (heavily formatted, not tabled). In order to prevent mistakes they’ve asked me to protect the workbook formulas whilst also maintaining the ability to keep functionality of adding more rows / columns. I’m having difficulty providing both. Example whilst the sheet is protected I can add a new row but it will not copy the previous formula (in my case, it’s a sequential reference to another sheet). I.e. Sheet1!A1, Sheet1!A2, etc. Very basic worked example: Cells A1:B10 are editable cells using edit ranges. Cells C1:C10 let’s say contain a basic formula =A*B. The sheet is protected but allows the inserting, formatting and deletion of rows / columns. I insert a row above row 10 the formula isn’t copied. I copy row 9 and insert above row 10 the protected sheet prevents me from doing this. Might just be me but I can’t see a way how this is possible without the use of Macros which I don’t want to do! submitted by /u/MrMC3113 [link] [comments]
- How to enable copy paste /copy sheet in excel?This folder does not protected password in first place? https://docs.google.com/spreadsheets/d/1XYeprsRV6-CdkSlaKsemBRPBGfbZzyQv/edit?usp=sharing&ouid=101357255801952580393&rtpof=true&sd=true submitted by /u/totalnewbielinux [link] [comments]