You can divide the area of a sheet containing data into two parts: an area where movement is unrestricted (scroll area) and an area where movement is restricted, meaning that it is protected.
You can set the scroll area in a sheet either by using the Scroll Area macro or by making a change in the sheet’s Properties dialog box.
Changing properties in the Properties dialog box
To change the sheet’s properties, you need to open the macro editor, VBE.
The result: in the range A1:C15, you can perform any action in the cells. In all the other cells in the sheet, you are restricted to viewing the cells and cannot move or scroll between them. Screenshot // Preventing Movement in Protected Areas in Microsoft Excel
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.