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

Restrict the accessible area by hiding a row(s) and/or a column(s).

To protect data in cells by hiding rows and columns:

To hide a row(s):
1. Select a row, for this example, select row 33 and press Ctrl+Shift+Down Arrow.
2. Select Home - Format (in Cells Group) - Hide & Unhide - Hide Rows or Hide Columns.
Or
Right click and select Hide from shortcut menu.
Result: The unrestricted area is the visible area, range A1:D32.

To hide a column(s):
1. Select a column(s), for this example, select column E and press Ctrl+Shift+Right Arrow.
2. Select Home - Format (in Cells Group) - Hide & Unhide - Hide Rows or Hide Columns.
Or
Right click and select Hide from shortcut menu.
Screenshot // Protecting Data by Hiding a Row(s) and a Column(s) in Excel 2007