You are here KNOWLEDGE Excel Tips Excel General Protecting Data by Hiding a Row(s) and Column(s)

Query, Share and Manage Excel workbooks on LAN, Internet

Protecting Data by Hiding a Row(s) and Column(s)

Restrict the accessible area by hiding rows and columns.

To protect data in cells by hiding rows and columns:

1. Select a column. For this example, select column E (see screenshot on the next page) and press Ctrl+Shift+Right Arrow.
2. Press Ctrl+0, or press Shift+F10 and select Hide from the shortcut menu.
3. Select a row. For this example, select row 32 and press Ctrl+Shift+Down Arrow.
4. Press Ctrl+ 9, or press Shift+F10 and select Hide from the shortcut menu.
Result: The unrestricted area is the visible area, range A1:D31.

To unhide rows and columns:

1. Select row 31, and while placing the cursor on the row number, click and drag it slightly downward into the non-accessible area.
2. Release the mouse button and return the cursor to row 31.
3. Press Ctrl+Shift+(, or press Shift+F10 and select Unhide from the shortcut menu.
4. Select column D, and while placing the cursor on the column number, click and drag it slightly to the right into the non-accessible area.
5. Release the mouse button and return the cursor to column D.
6. Press Ctrl+Shift+), or press Shift+F10 and select Unhide from the shortcut menu.

Screenshot // Protecting Data by Hiding a Row(s) and Column(s)
Protecting Data by Hiding a Row(s) and Column(s)