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

My Account

Check out

Shopping Cart

JOIN OUR NEWSLETTER
and receive for joining:
	Free eBook Learn More!
	Free Excel ADD-IN
	Free Weekly Excel Tip








F1 eBook (Spanish)

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

CATEGORY: Excel Security - Protection

VERSIONS: All Microsoft Excel Versions

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)