Quick and Easy Way to Unhide Scroll Bars in Excel

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!

• Genuine laptops

• How to fix the inability to move between cells in an Excel spreadsheet
• What is Scroll Lock? How to effectively use the Scroll Lock key

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.