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
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
