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) 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.Then, we will right-click on the selected cells > select Delete from the Context Menu.After that, we will release the CTRL+SHIFT keys.Now, we can see that our dataset gets unselected, and we can see all the cells from column F have been selected. Afterward, we will click on column A, hold on to the CTRL+SHIFT keys and we will drag toward the right.However, we want to unselect the dataset. Next, we will see that all the cells have been selected. After that, we will hold and drag the mouse toward left > we will type CTRL+SHIFT+Left Arrow keys.To do so, first, we will select column XFC.

Now, we have to delete the entire area from our dataset to the last cell. Afterward, we will mark the Last cell > click OK.First, we will go to the Home tab > select the Editing option > select Find & Select > select Go To Special.We will find out the last cell by using the Go To Special feature, and after that, we will adjust Scroll Bar in Excel. Therefore, it is clear that there is some data toward the left of the Excel sheet. The following picture shows a tiny horizontal Scroll Bar. Method-1: Using Go To Special Feature to Adjust Scroll Bar in Excel To solve this problem, we describe 5 methods to adjust Scroll Bar in Excel. Therefore, if we drag the Scroll Bar up and down or left and right the cell moves really fast. We can see both the horizontal Scroll Bar and the vertical Scroll Bar are very tiny. The following dataset contains the Date, Product Name, and Price columns.

No scroll bar in excel