Apr 22, 2021 · QUESTION: Is this possible? What I have tried: 1. Select all worksheet cells > Format Cells > Protection > un-check Locked 2. Select the Table column I want to protect > …

Jul 13, 2012 · Locking cells in columns but allow copying and adding rows I'm having real problems with locked columns in a worksheet which have formulas in them which are …

Jan 20, 2009 · The simplest (read "low-tech) way is to periodically lock the data for previous months in the DetailSheet. Select the range of cells you want to "lock" and CTRL-C to copy it, …

Nov 13, 2014 · I need to lock row together so that filters move whole rows not just cells. My top row is a series of filters the rest is just basically a form you fill out. The problem is if you filter …

May 12, 2012 · Re: Lock Page Breaks? But even when you protect a sheet and lock cells or even rows, another user can move the page break border and thus remove the cells from a printed …

Apr 2, 2015 · Lock cells with formula to prevent manual data entry into those cells. I`m trying to lock cells with formulas (so they only update when changes are made to other cells they refer …

Aug 26, 2015 · How do you "lock in" a cell color so that if you want to change cell colors later, that color won't change. In other words, one cell color has a priority over another one (e.g. yellow …

Jul 26, 2014 · A side-effect of unchecking "Select Locked Cells" is that users cannot select locked column headings if they want to copy and paste data elsewhere. This creates an awkward …

Jul 5, 2020 · Re: How to lock comments in Excel workbook? I do not think Excel provide locking comment as native feature. You only have an option to work around, I guess.

Nov 3, 2022 · Re: Lock cells then leave others to edit ? To be able manage the other unlocked cells, when you activate the sheet protection, you need to tick the needed items in the section: …