871 votes140 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Lead Program Manager
ExcelYossi Geretz supported this idea ·Yossi Geretz commented
This is a great idea - MUST HAVE. I am publishing a table. I'd like to solicit feedback by having the audience fill out the table and return to me. Several columns in the table are calculated. I want to lock the audience out of those columns. But as soon as I protect the sheet, the entire table is effectively locked.
As an aside, I would suggest that the protection paradigm in excel has been broken, or at least lacking a major use case for some time now. It should be much easier to lock a column while leaving the ability to add rows in an unfettered manner. This would effectively ensure that each row added would conform to the locked in columnar structure. This is a major use case. Can we get this to work with tables?