![how to rotate columns in excel how to rotate columns in excel](http://markimarta.com/wp-content/uploads/2016/01/excelrote-03.png)
Method-5: Excel VBA to Adjust Scroll Bar in Excel After that, we will right-click on cell B1048574 > select Delete Note from the Context Menu.įinally, when we will open our Excel file, we will see that the vertical Scroll Bar has become bigger and more manageable.We will see that there is a Note in cell B1048574 cell. Next, we will return to our Excel sheet, we will drag down the vertical Scroll Bar.We will select Advanced > we will mark i ndicators and notes, and comments on hover > click OK.Highlighting the comments/note and deleting them will adjust Scroll Bar in Excel. This is because there might be hidden comments/notes in this Excel file. In the following picture, we can see that the vertical Scroll Bar is tiny. Read More: Scroll Bar Not Working in Excel (5 Easy Fixes)
![how to rotate columns in excel how to rotate columns in excel](https://geekexcel.com/wp-content/uploads/2020/03/Screenshot_5-44.png)
This will clear up the values that are to the right and down of cell A16, and it will make the vertical Scroll Bar large.įinally, when we will open our Excel file, we will see that both the Scroll Bars have become bigger and more manageable. Afterward, we will go to the Home tab > select the Editing option > from Clear > select Clear All.Next, we will see that all the cells right and down of cell A16 will get selected. After that, we will click on cell A16, and we will type CTRL+SHIFT+Right Arrow+Down Arrow keys.This will clear up the values that are to the right and down of cell E1, and it will make the horizontal Scroll Bar large. Afterward, we will go to the Home tab > select the Editing option > select Clear > select Clear All.Next, we will see that all the cells right and down of cell E1 will get selected. First, we will click on cell E1 > we will type CTRL+SHIFT+Right Arrow+Down Arrow keys.Here, we will employ the keyboard shortcutto adjust Scroll Bar in Excel. In the following picture, we can see both the horizontal Scroll Bar and the vertical Scroll Bar are very tiny Method-3: Employing Keyboard Shortcut to Adjust Scroll Bar in Excel Read More: Vertical Scroll Bar Not Working in Excel (10 Possible Solutions)
![how to rotate columns in excel how to rotate columns in excel](https://cdn.extendoffice.com/images/stories/doc-excel/rotate-table/doc-kutools-filp-horizontal-1.png)
Now, when we return to our worksheet, we will see no Scroll Bar. After that, from the Display options from this workbook we will unmark Show horizontal scroll bar and Show vertical scroll bar boxes > click OK.Afterward, we will select the Advanced option.Therefore, we will get rid of the tiny Scroll Bar. Method-2: Applying Advanced Excel Option to Hide Scroll Barįor Hiding horizontal and vertical Scroll Bar, will use the Advanced Excel Option. Read More: Excel Horizontal Scroll Bar Not Working (8 Possible Solutions) Next, we have to save the file by clicking on the Save button or pressing CTRL+S.įinally, when we will open our Excel file, we will see that the horizontal Scroll Bar has become bigger and more manageable.
![how to rotate columns in excel how to rotate columns in excel](https://www.techonthenet.com/excel/cells/images/rotate2016_002.png)