Restrict the accessible area by hiding a row(s) and/or a column(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.


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.