How To Get The Scroll Bar Back In Excel

Is Your Excel Scroll Bar Missing? four Like shooting fish in a barrel Ways to Ready It

(Note: This guide on how to set the "Excel scroll bar missing" consequence is suitable for all Excel versions including Part 365.)

The scrollbar in Excel is a very important feature that allows the states to quickly ringlet through thousands of rows and columns without any hassle. It has become an integral part of Excel. Most of u.s.a. cannot fifty-fifty imagine working without it. But, sometimes the scrollbar can go missing, out of the blue, and getting it back can be a frustrating experience.

In this troubleshooting guide, we'll wait at how to bring back a curl bar missing in Excel

You'll larn:

Why is the Excel Curlicue Bar Missing?
How to Troubleshoot the Excel Scroll Bar Missing Issue?
- Fix ane – Enable the Excel Scroll Bar
- Fix two – Maximize the Roll Bar
- Ready 3 – Arrange the Tiles
- Prepare 4 – Resize the Excel Window

Related:

How to Fix the Excel Spill Error? — 5 Easy Fixes

How to Indent in Excel? three Piece of cake Methods

Pointer Keys Non Working in Excel – iv Like shooting fish in a barrel Fixes

Why is the Excel Scroll Bar Missing?

There might be a couple of reasons why the scrollbar goes missing in Excel all of a sudden. These reasons are:

Disabled curlicue bar – Excel provides an option through which the scroll bar can be disabled to increase cell visibility. At that place is a chance, you might have accidentally disabled it, when exploring the settings section.

MInimized scrollbar – There is an option to minimize the gyre bar right below it. Yous might take accidentally clicked it.

The coil bar is out of view – This happens when the Excel window is zoomed in or minimized. This may automatically hide or shrink the scrollbar.

How to Troubleshoot the Excel Scroll Bar Missing Issue?

Depending on the cause of the problem, ane of the following methods volition assistance you gear up the "scroll bar missing in Excel" outcome. Let's look at them one past 1.

Fix 1 – Enable the Excel Scroll Bar

1 of the easiest means to bring dorsum the scrollbar is to enable it again.
Permit's come across how to practice this:

Go to the 'File tab' and click on Options.

Open the 'Advance category' section. Now roll down and locate the 'Brandish option for the workbook' section

Under it, click on both the 'Horizontal scrollbar' and 'Vertical scrollbar' options

Fix the Excel Scroll Bar Missing Issue — *Fix the Excel Roll Bar Missing Issue* – *Cheque the tick box adjacent to the Horizontal and Vertical Scroll Bars options*

Click the 'Ok' button to save your changes.

Fix 2 – Maximize the Scroll Bar

If y'all are sure that your scrollbar is enabled but is still missing, in that location is a take chances that is just minimized. If that is the example, nosotros have to maximize the scrollbar by doing this:

You lot will see a small Iii Vertical dots button on the lower correct-mitt side of the sheet.

Click on that and drag information technology to the left-side to show the gyre bar.

*Maxismize the missing scroll bar in Excel*

Now, cheque if your spreadsheet is displaying the scrollbar.

Fix three – Suit the Tiles

In some versions of Excel, a missing scrollbar might occur if the tiles (open windows) aren't arranged correctly.

To fix this, we have to arrange them properly. Hither's how:

Click on the 'View tab' of Excel.

Click on the 'Adjust all' option.

Click on View > Arrange All — *Click on View > Accommodate All*

Select the 'Tiled' and switch to 'Ok' to save your changes.

Arrange windows in tiles to fix the missing scroll bar — *Arrange windows in tiles to prepare the missing scroll bar*

Fix 4 – Resize the Excel Window

Every bit mentioned earlier, Excel sometimes hides the scroll bar, if the Excel window is minimized or if its size is contradistinct.

Let'south encounter how to resize the file window to fix this:

Click on the file'south name-bar near the very height of the Excel window and drag it to accommodate the view.

Drag the Excel Window till the right-edge is visible — *Drag the Excel Window till the right-border is visible*

Elevate it till both the edges of the Excel window are visible to you.
Click on the Maximize button near the Close push.

Now, cheque whether the scrollbar has appeared on the spreadsheet.

Suggested Reads:

How to Autofit Excel Cells? 3 Best Methods

How to Excerpt an Excel Substring? – 6 Best Methods

How to Shade Every Other Row in Excel? (5 All-time Methods)

Let's wrap up

In this short troubleshooting guide, I have shown you how to find a missing scrollbar in Excel. I hope, y'all find these tips helpful. Please let us know which method helped you.

You can find more high-quality guides like this in our costless resources department.

Want to larn more about Excel? Click hither to access our advanced Excel courses with in-depth training modules.

You tin can train your entire team in Excel and other business software, for a single low monthly fee by clicking here.

Simon Calder

Chris "Simon" Calder was working as a Project Manager in Information technology for one of Los Angeles' virtually prestigious cultural institutions, LACMA. He taught himself to apply Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy and so, simply he spotted an opportunity and fabricated an online MS Project course - the residual, as they say, is history!