Quick and Easy Way to Unhide Scroll Bars in Excel

The process of displaying a scroll bar in Excel can be quite simple, making it easier for users to view a spreadsheet when the content is too long to fit in the visible space. However, not all users are aware of how to do this. So, how can you display a scroll bar in Excel?

By
Administrator
-
0
111

If you are experiencing a situation where Excel is not displaying the horizontal or vertical scroll bar, there’s no need to worry. This issue can be quickly and easily fixed in just a few steps. In this article, FPT Shop will guide you on how to show the scroll bar in Excel, in a simple and fast way.

What is a scroll bar? What is its purpose?

A scroll bar in Excel, also known as a scroll bar in English, is a scroll bar that appears when the content of a window is too long to be displayed in its entirety.

If the content in Excel is too long, a scroll bar will appear on the right side of the window, allowing you to scroll up and down the page. If the window is too wide, the scroll bar will appear at the bottom of the window, allowing you to scroll left and right on the page.

Note: This article is performed on a laptop running the Windows operating system using Excel 2016. In addition, you can also perform it on other versions of Excel software such as Excel 2007, 2010, 2013, 2019, and on MacOS with the same steps.

How to show the scroll bar in Excel 2010, 2013, 2016

To display the scroll bar in Excel is quite simple and easy. You can follow the detailed instructions below.

Quick Guide

First, open the Excel file > Select the File tab > Continue by selecting Options > In the Options interface, select Advanced > Find and select the Display section > Check the boxes for Show horizontal scroll bar and Show vertical scroll bar > Finally, click OK to show the scroll bar in Excel.

Detailed Instructions

Step 1: Open the Excel file > Select the File tab on the toolbar.

Step 2: Press Options.

Step 3: At the Options interface, select Advanced > Find and select the Display options for this workbook section > Then, check the boxes for Show horizontal scroll bar and Show vertical scroll bar.

Where:

  • Show horizontal scroll bar: This will display the horizontal scroll bar.
  • Show vertical scroll bar: This will display the vertical scroll bar.

Step 4: Finally, click OK to show the scroll bar in Excel.

How to show the scroll bar in Excel 2007

Displaying the scroll bar in Excel 2007 is quite simple and easy. You can follow the detailed instructions below.

Quick Guide

Open the Excel file > Click the Microsoft Button > Continue by selecting Excel Options > In the Options interface, select Advanced > Find and select the Display section > Check the boxes for Show horizontal scroll bar and Show vertical scroll bar > Finally, click OK to show the scroll bar in Excel.

Detailed Instructions

Step 1: Open the Excel file > Click the Microsoft Button > Continue by clicking Excel Options.

Step 2: At this point, the Options interface appears, select Advanced > Find and select the Display section > Then, check the boxes for Show horizontal scroll bar and Show vertical scroll bar.

Where:

  • Show horizontal scroll bar: This will display the horizontal scroll bar.
  • Show vertical scroll bar: This will display the vertical scroll bar.

Step 3: Finally, click OK to show the horizontal and vertical scroll bars in Excel.

How to show the scroll bar in Excel 2003

The process of displaying the scroll bar in Excel 2003 is quite simple. You can follow the detailed instructions below.

Quick Guide

Open the Excel file > Click on the Tools tab > Continue by selecting Options > Then click on the View section > Finally, check the boxes for Horizontal scroll bar and Vertical scroll bar to display the scroll bar again.

Detailed Instructions

Step 1: Open the Excel file > Click on the Tools tab > Then select the Options section.

Step 2: Continue by clicking on the View section > Then check the boxes for Horizontal scroll bar and Vertical scroll bar to display the scroll bar again.

Where:

  • Show horizontal scroll bar: This will display the horizontal scroll bar.
  • Show vertical scroll bar: This will display the vertical scroll bar.

In conclusion

Above, FPT Shop has guided you on how to show the scroll bar in Excel, in a simple and fast way. If you find the article helpful, don’t forget to share it with others!

You may also like

Detailed, Simple, and Fast Guide to Using the TRANSPOSE Function in Excel

If you are looking to switch the columns and rows in Excel and Google Sheets, you can use the TRANSPOSE function. This function allows you to convert columns into rows and vice versa. If you are unfamiliar with how to use the TRANSPOSE function, do not worry. In this detailed tutorial, we will guide you through the simple and quick steps to use this function effectively.

Frequently asked questions

To quickly unhide scroll bars in Excel, simply right-click on the worksheet tab, select ‘View Code’ from the menu, and then delete the following line of code: ‘ActiveWindow.DisplayScrollBars = False’. This will immediately restore the scroll bars, allowing you to navigate the worksheet with ease.

There could be a few reasons why your scroll bars have disappeared in Excel. One common reason is that a macro or VBA code has been run which hides the scroll bars to create a full-screen effect. Another reason could be that your Excel settings have been modified to hide the scroll bars, either intentionally or accidentally.

To ensure that your scroll bars remain visible in the future, you can take a few precautions. First, be cautious when running macros or VBA code, and ensure that you understand their effects before executing them. Second, check your Excel settings and ensure that the option to display scroll bars is enabled. You can find this option in the ‘Advanced’ section of the Excel Options menu.

Yes, even if your scroll bars are hidden, there are alternative ways to navigate your worksheet. You can use the arrow keys on your keyboard to move between cells, or you can click and drag the fill handle in the bottom-right corner of the worksheet to quickly scroll through the entire sheet. Additionally, you can use the Page Up and Page Down keys to move up and down the worksheet.

Yes, Excel allows you to customize the appearance of scroll bars to some extent. You can change the color and thickness of the scroll bars by navigating to the ‘Advanced’ section of the Excel Options menu and adjusting the settings under ‘Display options for this worksheet’. These settings allow you to make the scroll bars more visible and easier to use.

RELATED ARTICLESMORE FROM AUTHOR