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.

Again, starting in the Cells group, click Format | Protect Sheet.

Starting in the Cells group, click Format | Hide & Unhide | Hide Columns.

With the column still selected, display the Home tab of the ribbon.

(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. With the entire sheet selected, it doesn't matter where in the headings you right-click.Roger has a worksheet that he needs to distribute to different people so they can add and change some information. You can then right-click on row and column headings and select Unhide for each. If you'd like to unhide all rows and columns in a worksheet, first, select the entire worksheet. Then, right-click in the row selection and choose Unhide from the menu.

Notice the gap in row numbers when rows are hidden.Īs with columns, you need to select rows on both sides of the rows you want to unhide. Or, you can use the right-click menu, which is faster. You can hide and unhide rows using Hide Rows and Unhide Rows in the Format menu. Rows work in much the same way as columns. Then, right-click and choose Unhide from the menu. To unhide the columns, make sure to select columns on both sides of the hidden columns. Select one or more columns, right-click in the selection, and choose Hide from the menu. You can also hide and unhide columns using the right-click menu.

Then, choose Unhide Columns from the Format menu. To unhide a column, you need to select columns on both sides of the hidden column.

Notice that when a column is hidden, its heading is also hidden, so that there is a gap in the column letters that run across the top of the worksheet. One way to hide a column is to choose Hide Columns from the Format menu on the home ribbon. Hiding rows or columns is a good way to visually simplify a worksheet without removing important information. In this lesson, we'll look at how to hide and unhide columns and rows.

How to hide columns in excel 2016