Excel 2016 - restrict certain columns

[dloudon96]

Hi,

 

I'm wondering if it's possible to restrict certain columns from being edited, or create a button where it asks for a password to edit the column(s). We've got a spreadsheet which is confidential, but want to hide a set of columns from being shown, or blank out the information from being seen, but don't want the users to be able to edit them columns or see the information without the password.

 

Please let me know if any of that doesn't make sense.

 

Thanks,

 

Dan

[Seb1780]

Look under the "Review" tab for the "Changes" menu - you can use this to protect certain cells and allow editing of others.

 

To hide columns select them, right click and hide!

 

Once a worksheet is protected you would need a password to unprotect and unhide.

[TechMonkey]

If you protect a sheet hidden columns cannot be unhidden until the sheet is unprotected. To protect a sheet click the file tab (top left), click the "Protect Workbook" button and choose "Protect Current Sheet" and give it a password.

[howartp]

By default all cells are protected, just the workbook isn't locked against edited.

 

So if you try it out by locking it, you'll find you can't click anywhere!