In the unlocked cell, enter a formula that references a locked and hidden cell.If you have some cells in the worksheet (or workbook) that are unlocked, so that the contents of the cell can be changed, it is still possible to see what is in individual cells of the column. You are prompted to reenter your password (the one from step 8), which you should do.Īt this point someone cannot view what is in the hidden column, even if they use F5 to jump to one of the cells in the column it still won't appear in the formula bar. (These two options are selected by default in a worksheet.) At a minimum you should choose Select Locked Cells and Select Unlocked Cells. Using the check boxes, select what type of protection you want applied to the worksheet.Enter a password to be used in protecting the worksheet.Excel displays the Protect Sheet dialog box. Choose Tools | Protection | Protect Sheet.With the column still selected, choose Format | Column | Hide.(It is the Hidden check box that controls whether the cell contents are visible in the formula bar or not.) Make sure both the Locked and Hidden check boxes are selected.The Protection tab of the Format Cells dialog box. Make sure the Protection tab is displayed.Excel displays the Format Cells dialog box. Since you already know how to protect a worksheet, you are already on your way to accomplishing your task.

He knows how to protect the worksheet and how to hide data in cells, but noticed that info is still visible in the formula bar. He wants to hide some of the columns in the worksheet, however, so that they cannot be viewed by users. Roger has a worksheet that he needs to distribute to different people so they can add and change some information.

How do i unhide a column in excel 2007