•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
protect all but one cell
Our take
To create an Excel spreadsheet where only one cell is editable while protecting the rest of the content, you can use the "Protect Sheet" feature without requiring a password. First, unlock the specific cell designated for data entry by selecting it and navigating to Format Cells > Protection, then uncheck "Locked." Afterward, protect the sheet by going to Review > Protect Sheet, ensuring that "Select locked cells" is disabled.
I created a excel spreadsheet for co-workers to type a date into one cell and new date ranges appear based on that one cell. The sheet also has other info that I don't want disturbed. How can I make it so that just that one cell allows for data entry without making a password for the sheet?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- New cells added to a protected sheet will not lockI 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. submitted by /u/middleCHILD-problems [link] [comments]
- Excel Online... is there a way to stop users from deleting rows/columns but still allow them add and delete text from cells?Ok, I'm pretty stuck on this one and am not sure why. I'm using Excel Online (yea, I know... it sucks). I'm attempting to create a filterable table in A1:M1000 that users can enter data into. Where I'm stuck is this... I want users to be able to enter/delete (delete by selecting an entire row and hitting 'delete'), use drop downs, and filter A:M all within that range. I do not want them to be able to edit anything outside of that range (so N -> beyond and 1001 -> beyond) AND I do not want them to be able to add or delete rows/columns across the entire sheet. My hiccup is coming here... how do I lock the sheet while allowing users to add data to A1:M1000, select a row and hit 'delete', but NOT add or delete rows/columns? I've attempted to lock the entire sheet but unlock A1:M1000; however users then cannot select and entire row and hit delete. Anyone have any helpful tips for this? submitted by /u/Tacticool_Turtle [link] [comments]
- Calculated cells are not displayed when in protected modeI'm generating an Excel file from software I'm writing. The spreadsheet contains numbers and some cells with formulas. This works fine. But when users download these files, all the cells that contain formulas are not displayed. They are simply blank. Not until the user hits the Enable Editing button do the calculated values appear. https://preview.redd.it/5vlwzrlrttsg1.png?width=1092&format=png&auto=webp&s=2a38bae278bf63ce2802b20efa1bb088d1f78f77 I understand this is some sort of protection. But I don't understand how hiding these cells protects anything. Is there any way to get these cells to appear when the spreadsheet is first downloaded and displayed. submitted by /u/NobodyAdmirable6783 [link] [comments]
- Password to edit, but password no longer on the spreadsheetI've got a spreadsheet that previously required a password to edit. I've since removed that password requirement and it opened okay for a few weeks; however it's now reverted to asking for a password to edit again. I've checked into the field where the password was (is) held and it is blank [Tools > General Options] and yet it still asks for this info. If I change it so that it does require a password to edit, then it does require the new password that I add. And if I then subsequently remove that password, then Excel still requires me to enter the new password that I have just added. Any thoughts as to what's going on? I've asked an AI and it had a few suggestions, all of which I've tried, but I'm still at the same place. submitted by /u/_Okie_-_Dokie_ [link] [comments]