fasaddenver.blogg.se

1. #HOW TO HIDE AND UNHIDE A COLUMN IN EXCEL HOW TO#
2. #HOW TO HIDE AND UNHIDE A COLUMN IN EXCEL FULL#
3. #HOW TO HIDE AND UNHIDE A COLUMN IN EXCEL PASSWORD#
4. #HOW TO HIDE AND UNHIDE A COLUMN IN EXCEL PLUS#

Then you will see hidden columns are locked and protected, while other cells in current sheet works as normal.

#HOW TO HIDE AND UNHIDE A COLUMN IN EXCEL PASSWORD#

Hide these columns, and then protect current sheet by clicking Design (or Review) > Protect Sheet, and type your password into both dialog box as following screen shot shown:

(2) Holding the Shift key, you can select multiple adjacent columns by selecting the first columns and the last one.Ĥ. (1) Holding the Ctrl key, you can select multiple nonadjacent columns by selecting each column one by one Select the columns that you will hide and protect, and then click the Design > Lock Cells.

#HOW TO HIDE AND UNHIDE A COLUMN IN EXCEL PLUS#

Click the Kutools Plus > Worksheet Design to activate the Design tab, and then click the Unlock Cells to unlock all cells in current sheet.ģ.

#HOW TO HIDE AND UNHIDE A COLUMN IN EXCEL FULL#

Full feature free trial 30-day, no credit card required! Free Trial Now!Ģ. Kutools for Excel- Includes more than 300 handy tools for Excel. If you have Kutools for Excel installed, its Selection Lock utility and Selection Unlock utility will help you much easier to protect/lock hidden columns in Excel. Note: Because you have removed the locked status from all cells, you can enter data into the cells of worksheet as normal. See screenshots:Īnd when you unhide the columns with the Unhide function, the Unhide tool will become gray, so that you can't unhide the hidden columns. And in the Protect Sheet dialog, enter your password and confirm it. In this step, you can hide the selected columns, and then go to clicking Review > Protect Sheet.Ħ. And then click OK to close the dialog, see screenshot:ĥ. In the Format Cells dialog box, click Protection tab, and then check the Locked option. And 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. Click the Select All button (the button at the intersection of row numbers and column letters). Then, right-click and pick “Unhide” in the shortcut menu.In Excel, the following steps can help you prevent the hidden columns from seeing, please do as this:ġ. You can do this easily by dragging through them. Select the columns on each side of the hidden column(s). When you’re ready to view those hidden columns, unhiding them is just as simple as hiding them.

#HOW TO HIDE AND UNHIDE A COLUMN IN EXCEL HOW TO#

RELATED: How to Freeze and Unfreeze Rows and Columns in Excel Unhide Columns in Microsoft Excel If you’d like to keep certain columns on screen while you scroll through your spreadsheet, learn how to freeze columns and rows in Excel. This is a good thing to keep in mind if you’re looking for data you don’t see. If you’re using a Mac, this indicator may appear as a bold green line. Right-click one of them and pick “Hide” in the shortcut menu.Īfter you hide columns in Excel, you’ll see a thick white line indicator between the remaining column headers. Once you choose the columns you want to hide, they’ll be highlighted.