Jan 30, 2015 · Step 1: Make cells editable so that sorting will work. Add cells we want to sort to a range and make that range editable in “Allow Users to Edit Ranges.” This allows users to edit …

Jun 24, 2013 · I need to protect some columns with formulas in an Excel Table. Is there any way I can do this without using a macro. The moment I convert my data to a table the protection …

Apr 28, 2018 · Hello, In one of my protected sheets (only two options checked in protect dialog: "select locked cells" and "select unlocked cells"), I want to allow the users to only be able to …

Aug 19, 2010 · Can anyone kindly tell me how I can protect some columns of a dynamic table but still allow users to create new rows and formula in the locked columns are carried down.

Feb 21, 2011 · Hi All, I'm stuck on a multiple lock macro that i'm hoping you can help me with I have a worksheet where I need to lock multiple columns before I protect...

May 15, 2015 · Hey guys. I have a protected worksheet so that people in my office do not break some hidden formulas. There are three columns on the sheet that we want to be able to hide …

Jan 11, 2012 · Hi everyone I am using Excel 2010. I am looking to protect Cells within a worksheet but for users to be still able to hide Rows and Columns with protected cells in …

May 26, 2010 · Hello, You can hide the column or hide the formula (if applicable) in the column. Select the range of cells whose formulas you want to hide. You can also select nonadjacent …

Oct 11, 2012 · Hi itis, this one was a little challenging First thing that needs to happen is to set the protect sheet options: allow users to select locked cells, select unlocked cells, insert rows. …

Feb 3, 2020 · I have a spreadsheet I need to share and allow people to edit - However I need them to stop hiding cells as it is causing big problems later on as not everyone knows how to …