Contents • • • Sometimes, if you want to limit scroll area of an Excel worksheet, it means that the cells outside the scroll area cannot be selected. Are there any quick tricks to limit the scroll area on an Excel worksheet? Limit Scroll Area by Entering the Range Address Manually • Open the workbook. • Activate the worksheet that you want to limit the scroll area. • Activate the Visual Basic Editor by pressing ALT F11. • Pressing F4 to show Properties Window. • In the Properties Window list, enter a contiguous range address in the ScrollArea property box, in this example, we enter A1:F14, see screenshot: • Close this Properties window and back to worksheet, and you will be restricted to select the cells outside the range you are specified.

In this example, you can't select cells outside the range A1:F14. • If for some reason you need to cancel the scroll area limits, you just need to delete the range address from the ScrollArea property box in above step 5. Limit Scroll Area use bulid-in command: Hide For example, if you want to limit scroll area to A1:F14, you can hide the cells outside the range A1:F14, please do with the following steps: • Select Column G, and then press CTRL SHIFT →, then press Ctrl 0 or Right click and choose Hide • Select Row 15, and then press CTRL SHIFT ↓, then press Ctrl 9 or Right click and choose Hide.

• Now, you will be restricted to select the cells outside the range A1:F14, see screenshot: If you want to Unhide the ranges, do with the following steps: • Hold and click Column F, then move right the mouse, over the Column F, it will display 16379C (Excel 2010), then press CTRL SHIFT 0 or Right click and choose Unhide. • Hold and click Row 14, then move down the mouse, over the Row 14, it will display 1048563R (Excel 2010), then press CTRL SHIFT 9 or Right click and choose Unhide. Limit Scroll Area use Excel VBA If you want to limit scroll area use Excel VBA code, read this article.

Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.

Defend your data privacy with the best Mac VPN. Use StrongVPN to begin protecting your private files, communications, photos, and more. Download our easy-to-use Mac VPN setup guides to get started today! Choose from L2TP, SSTP, OpenVPN, IPSec, and IKEv2 protocols. Compatible with Yosemite, El Capitan, Sierra and Mojave OSX. Strong vpn for mac sierra. News Corp is a mac os sierra vpn setup network of leading companies in the 1 last mac os sierra vpn setup update 2019/02/04 worlds of diversified media, news, education, and information services.

Sometimes, if you want to limit scroll area of an Excel worksheet, it means that the cells outside the scroll area cannot be selected. Are there any quick tricks to limit the scroll area on an Excel worksheet? Limit Scroll Area by Entering the Range Address Manually. Open the workbook. Activate the worksheet that you want to limit the scroll area.