There's no such thing as a stupid question, but they're the easiest to answer.


Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Missing scroll bars in Excel 2007


dataminer_1's Avatar
dataminer_1 dataminer_1 is offline
Computer Specs
Junior Member with 1 posts.
Join Date: Dec 2011
Location: Santa Barbara, Ca
Experience: Advanced
13-Dec-2011, 01:15 PM #1
Missing scroll bars in Excel 2007
How do I restore the horizontal and vertical scroll bars in Excel 2007? Also, the sheet tabs are missing
etaf's Avatar
etaf   (Wayne) etaf is online now
Computer Specs
Moderator with 55,254 posts.
Join Date: Oct 2003
Location: Surrey, UK
13-Dec-2011, 01:21 PM #2
are you in full screen view - as they are normall off - otherwise
In tools - options - view, both the horizontal & vertical scroll bars are ticked.
gkaytaz's Avatar
gkaytaz gkaytaz is offline
Junior Member with 1 posts.
Join Date: Dec 2011
Experience: Advanced
28-Dec-2011, 05:05 AM #3
Lightbulb If the scrollbars are still missing...
I hope etaf's solution does work. However if the problem persists it is possible that the Excel workbook you are working on is protected. Assuming you are using Excel 2007, go to Review menu and click on "Protect Workbook". On the dropdown menu see if "Protect Structure and Windows" option is checked. Trying to untick it will most probably result in an "enter password" prompt.

The workbook protection will prevent you from changing the layout of the Excel worksheet by disabling scrollbars, sheet tabs at the bottom of the screen, as well as removing maximize, minimize, restore and close buttons for the sheet (those for the sheet only, not for the Excel main window). The worksheet will just sit there, unmovable, unresizable and practically drive you crazy.

For a remedy you may want to search for "Excel protection remover" on Google. There should be a few freeware codes available. While they do not show you the actual password or remove Excel "file passwords" (those that prompt when you try to open a file) they do a commendable job on removing the workbook protection.

Hope this helps a little...

Merry X-mas and a Happy New Year everyone...
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

You Are Using: Server ID
Trusted Website Back to the Top ↑