Missing scroll bars in Excel 2007

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

dataminer_1

Thread Starter
Joined
Dec 13, 2011
Messages
1
How do I restore the horizontal and vertical scroll bars in Excel 2007? Also, the sheet tabs are missing
 
Joined
Dec 28, 2011
Messages
1
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...
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

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.

Join over 807,865 other people just like you!

Latest posts

Members online

Top