How to Adjust Scroll Bar in Excel (5 Cases)

Get FREE Advanced Excel Exercises with Solutions!

To adjust the scroll bar, follow the steps below:

  1. Select the whole row after the last row of the data table.
  2. Press the Ctrl + Shift + Down Arrow keys to select all the rows below.
  3. Under the Home tab, go to the Editing group> Clear > Clear All or press the Ctrl + ‘-’ buttons.
  4. Press Ctrl + S to save the document.

After that, you will see that the vertical scroll bar is adjusted. Use the Right Arrow to select all the columns on the right side and follow the same process to adjust the horizontal scroll bar.


Sometimes, the scroll bar in Excel becomes smaller because of scrolling down or right. In this case, if users drag the scroll bar up and down or left and right then, the cell moves fast. As a result, it creates problems.

In this Excel tutorial, you will learn how to adjust the scroll bar. Users need to do this to ease the navigation between cells.

Here is an overview of how the scroll bar can be adjusted. You can see that, after clearing the data outside the used range, the scroll bar is adjusted to its default size.

Overview of Adjusting Scroll Bar


Why Do We Need to Adjust the Scroll Bar in Excel?

You may have unwanted data in the 100th, 200th, or even in lower rows after completing your task with a large dataset. You may forget to delete a row of that dataset or any charts and notes of it. This makes the used range of the worksheet large. As a result, the size of the scroll bar becomes tiny and the situation makes scrolling faster. The size of the scroll bar is determined by the size of the used range in an Excel worksheet. Here is a scenario of this issue.

Fast Scrolling Problem

You can see that moving the scroll box a bit downward jumps to a very distant row (7494th row). Also, the movement of the column range by the horizontal scroll bar is too fast. It’s because the worksheet has data in distant ranges. For this reason, we need to adjust the scroll bar.

However, if you use the scroll wheel of the mouse or click the arrow buttons in the scroll bar, you won’t face this problem. The scroll bar doesn’t need to be adjusted in that case.


5 Cases to Adjust Scroll Bar in Excel

Earlier, you’ve seen that the appearance of a tiny scroll bar makes the scrolling too fast. So you should adjust it to its default size. Here, I have discussed 5 different cases when the scroll bar needs to be adjusted:


Case 1: Clearing Unnecessary Data Outside the Used Range

After deleting the data in the data range, there can be some data or comments or notes ignored by the users. By following the procedures here, you can adjust the scroll bar by removing any unseen data.

To adjust the scroll bar by clearing unnecessary data outside the used range, follow the steps below:

  1. Select the whole row after the last row of the data table.
  2. Press the Ctrl + Shift + Down Arrow keys together.
  3. Under the Home tab, select Editing > Clear > Clear All or press the Ctrl + ‘-‘ keys.
  4. Press Ctrl + S to save the document.
    Adjusting Vertical Scroll BarYou can see that the vertical scroll bar is adjusted.
  5. Similarly, select the whole column after the last column.
  6. Press the Ctrl + Shift + Right Arrow keys together.
  7. Clear all data and save the document.
    Adjusting Horizontal Scroll BarYou can see that the horizontal scroll bar is adjusted too.

The advantage of this method is that you don’t have to find any element like cell content or comments manually. All the unnecessary data gets deleted and thus the scroll bar gets adjusted as well.

However, if the above procedures cannot adjust the scroll bar, follow the steps below:

  1. Press Alt + F11 to open the Visual Basic editor.
  2. Select View > Immediate or press Ctrl + G to open the Immediate window.
    Opening Immediate Window
  1. Now, type UsedRange in the Immediate window.
    Typing Code in Immediate Window4. Press Enter.

Go back to your sheet and see that the scroll bar gets adjusted.

Read More: How to Insert Scroll Bar in Excel


Case 2: Removing Hidden Charts or Other Objects in Lower Cells

Sometimes users may forget to remove charts while deleting data from a large dataset. This may cause the same problem as shown earlier. In that case, you should remove the existing charts.

To remove unseen or hidden charts from a worksheet, follow the steps below:

  1. Press Ctrl + G to open the Go To dialog box.
  2. Select Special.
    Opening Go To Special Feature
  3. Choose Objects from the Go To Special dialog box and click OK.
  4. Then the charts or other objects will be selected.
  5. Press the Delete button on the keyboard.
  6. Move the scroll box to the top and save the document.
    Removing Hidden ChartsYou can see that the scroll bar gets adjusted.

If you see that the problem still persists, then there may be completely hidden charts, just like a hidden column or row. In that case, you should unhide the charts and remove them.

To unhide hidden charts, follow the steps below:

  1. Under the Home tab, select Editing > Find & Select > Selection Pane.
    Opening Selection Pane
  2. Now, toggle the unhide icon beside the chart name.
    Showing Charts from Selection Pane

Follow the steps shown in this method to remove the chart.

Read More: How to Remove Scroll Bar in Excel


Case 3: Dragging Vertical Ellipsis to Right or Left

This issue concerns adjusting the horizontal scroll bar. If the horizontal scroll bar becomes wide, it may cover the area of the sheet names. It can cause problems for users to view the data in the sheets properly.

In this case, you need to drag the vertical ellipsis (three vertical dots) to the right or left to adjust the horizontal scroll bar. You can see the procedure in the following GIF.

Adjusting Scroll Bar by Vertical Ellipsis


Case 4: Limiting Scroll Area

If you want to work in a fixed range of your Excel worksheet, you can set a scroll area for the sheet. This can also adjust the scroll bar as well.

To adjust the scroll bar by limiting scroll area, follow the steps below:

  1. Select Developer > Properties.
  2. In the Properties window, define the ScrollArea.
    Limiting Scroll Area
  3. Close the window.
    Now, your worksheet scroll bar is adjusted and cannot be scrolled to a longer range.
    Adjusting Scroll Bar by Limiting Scroll Area

Case 5: Resizing Objects, Charts or Shapes

Presence of large objects or shapes can be another reason for fast scrolling. In that case, we have to adjust the scroll bar.

To adjust the scroll bar, just resize or delete the object or shapes to a smaller shape. See the image below.

Resizing or Deleting Large Objects

Here, the bar chart is resized and the note is deleted. The scroll bar gets adjusted as well.


Download the Workbook


Conclusion

To sum up, you will learn some important necessary tips on how to adjust the scroll bar in Excel. Here, we discussed some different scenarios and showed how to adjust the scroll bar in those situations. If you have any questions or feedback, regarding this article, please share them in the comment box.


Frequently Asked Questions

How to hide or display the scroll bar in Excel?

To hide or display the scroll bar in Excel, follow the steps below:

  1. Select the File tab.
  2. After selecting Options, choose Advanced.
  3. To show the scroll bars, uncheck or select the Show horizontal scroll bar and Show vertical scroll bar checkboxes under Display options for this workbook.

Can I customize the appearance of the scroll bar in Excel?

Excel does not provide extensive customization options for the appearance of the scroll bar. The appearance is generally determined by the theme and settings of your Excel application.


Related Articles


<< Go Back to Scrollbar in Excel | Excel Parts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo