How to protect / lock hidden columns in Excel? - ExtendOffice.com

In Excel, Hide and Unhide columns are common functions that you may use ... Click the Select All button (the button at the intersection of row numbers and column letters), ... And in the Protect Sheet dialog, enter your password and confirm it.

www.extendoffice.com