![]() (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.
0 Comments
Leave a Reply. |