How To Restrict The Usable Space In An Excel Worksheet
To manage or restrict the scroll space of an Excel worksheet be used to both information or limit the consumer to solely use areas they're required to, otherwise you wish to permit entry to or permit for ease of navigation on a worksheet.
There are two methods to attain this restriction. The distinction between the 2 strategies relies on whether or not you want a brief or extra everlasting answer.
Let's take the non permanent answer first. This manner is to Set The Scroll Space Property.
1. To start with you want to be sure that the Developer Tab is seen in Excel. If it isn't you want to allow it. You may simply do that by deciding on:
- Excel Choices
- Fashionable
- Present Developer Tab
2. Choose Developer
3. Controls
4. Properties
5. Within the properties window enter the scroll space you wish to. This must be entered manually (typed) in. For Instance a cell vary of A2:D10 you want to sort in A2:D10.
After you could have typed in your vary of cells, you may then solely scroll these few cells and can't activate something exterior that set space. That is nice methodology if you want to restrict entry to a desk in that vary of cells.
As already acknowledged this sadly this isn't a persistent or everlasting function. The scroll space property is reset while you save your file, shut it then reopen it. If this doesn't present the answer you want there's another strategy to set the scroll space in an Excel worksheet.
This includes a small piece of Visible Primary (VB) information which I'll share with you.
1. Hit ALT + F11 keys in your keyboard to open the visible fundamental editor in Excel
2. Click on on 'ThisWorkBook 'within the Mission VBA Window
3. You'll now see the 'ThisWorkbook 'code module- double on it click on to open it
4. Enter or copy the next code into 'ThisWorkbook' code module
Personal Sub Workbook_Open()
Worksheets("Sheet1"). ScrollArea = "A2:D10"
Finish Sub
5. Press ALT+F11 to exit out of the VB editor to return to Excel regular view
6. Save the workbook as regular after which re open it.
In case your workbook has an.xlsm extension it would have to be saved as as macro enabled workbook (.xlsm) extension to permit this function to work. This shall be a everlasting strategy to set the scroll space in your workbook till you resolve to alter it.