Untick Show horizontal scroll bar and Show vertical scroll bar and press ok. Scroll down to find Display options for this workbook Using Excel advanced options, it is possible to remove the scroll bars from Excel workbooks. Turning off Vertical and Horizontal scroll bars in Excel Options The user will no longer be able to scroll past the area of the dashboard. Select the first row below the dashboard and then press Ctrl + Shift + Down arrow to select all the rows to the bottom of the sheet. We can also lock the scroll down in the same way. This will hide all columns to the right of the dashboard and the user will no longer be able to scroll further to the right than the dashboard. Then press Ctrl + Shift + Right arrow to select all the cells to the right of the sheet. Start by selecting the first column of blank cells after the dashboard. This way the user cannot ‘lose’ the dashboard because they have scrolled too far, and it will give the dashboard a more app-like feel. However, when you are creating a dashboard or other spreadsheet application, to improve the user experience, it is often a good idea to lock the scroll. Worksheet or workbook protection does not lock the scroll unless you first ensure the cells outside the scroll area are locked and cannot be selected. When you have protected a worksheet and workbook, the user retains the ability to scroll to the far side or bottom of the worksheet. Worksheet Protection to limit the screen scroll area Our Dashboard contains information from cells A1 to U40 and we want to lock the screen so the user is unable to scroll beyond this point. The first using Worksheet protection, the second using advanced excel options, and the third, using VBA. In this article, we will look at 3 ways to set the screen scroll lock area in Excel. Setting the screen scroll lock area improves the user experience and can make a dashboard or other spreadsheet application have more of that App like feel. ****Scroll to the bottom for the video***** A perfect example would be Excel Dashboards. Often there are times when a spreadsheet developer has the need to set the screen scroll lock area in Excel restricting where the user can scroll and has visibility.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |