![]() ![]() When you try to unhide the columns with the Unhide function, the Unhide tool is disabled, so that you can’t unhide the hidden columns. ![]() In this step, you hide the selected columns, and then go to clicking Review > Protect SheetĪnd in the Protect Sheet dialog, enter your password and confirm it. In the Format Cells dialog box, click Protection tab, and then check the Locked option. Then select the columns that you want to protect, and right click again, select Format Cells from the context menu. Then click OK button to close this dialog. Then right click, and choose Format Cells from the context menu, and in the popping out Format Cells dialog box, click Protection tab, and uncheck the Locked option. Here is how you protect that sensitive data, be it salary information or profit and loss statistics, so that just the right people see just the right information.Ĭlick the Select All button (the button at the intersection of row numbers and column letters). Where security is concerned you cannot be too careful and you may need to password protect your worksheet especially if you have to report to a wider group in a Head Office or Group role. Hide And Password Protect Just One Column In A Master Spreadsheet Password Protect Excel and Hide Just One Column ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |