![]() ![]() Open Excel Options (File -> Options), go to Advanced, then "Display options for this workbook". Sub SetAllScrollAreas()Īs an aside note, To stop Showing the horizontal scroll bar: You need to add a Module and add the following code to it. Or you can use a macro to set it when you open workbooks.Įdit: From this article also explaining the process above, there is a code of macro to accomplish setting up the scrollable area for a workbook. However, this only work for a worksheet, and you will have to set it for every single worksheet (which might be inconvenient). From now on when you try to go beyond the set limit, you will be taken back to area you defined. ![]() ![]() To do so, on the Developer tab, click on properties then on SCrollableArea, enter the range. Step 1: Click the File tab in Excel 2010 or higher version, or click the Microsoft Office Button button in Excel 2007 Step 3: In the Excel Options dialog box, go to the Advanced category Step 4: Scroll down to the Display options for this workbook section Step 5: Checked or unchecked the Show Horizontal Scroll bar option and Show Vertical. A partial possible solution is to limit the scrolable area. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |