ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel Scroll Bar (https://www.excelbanter.com/excel-discussion-misc-queries/193122-excel-scroll-bar.html)

rexmann

excel Scroll Bar
 
Hi All

I have a problem with one sheet within a workbook. The sheet seems to have
the scroll bar frozen and the Page down doesn't work properly. I have looked
under options but no joy.

Is there a disable option hidden away? Any help greatly appreciated

Kind regards

Rexmann

Dave Peterson

excel Scroll Bar
 
If you hit the pagedown/pageup buttons a few times, does the address of the
activecell change in the namebox (to the left of the formulabar)?

If yes, then maybe you're looking at a worksheet that has had data|Freeze panes
applied in the wrong position.

I'd try:
Window|Unfreeze panes.

If that doesn't work, maybe you can't scroll is because rows or columns are
hidden???

rexmann wrote:

Hi All

I have a problem with one sheet within a workbook. The sheet seems to have
the scroll bar frozen and the Page down doesn't work properly. I have looked
under options but no joy.

Is there a disable option hidden away? Any help greatly appreciated

Kind regards

Rexmann


--

Dave Peterson

rexmann

excel Scroll Bar
 
Yes, yes that's it, been bugging me for the whole night! Thanks Rexmann

"Dave Peterson" wrote:

If you hit the pagedown/pageup buttons a few times, does the address of the
activecell change in the namebox (to the left of the formulabar)?

If yes, then maybe you're looking at a worksheet that has had data|Freeze panes
applied in the wrong position.

I'd try:
Window|Unfreeze panes.

If that doesn't work, maybe you can't scroll is because rows or columns are
hidden???

rexmann wrote:

Hi All

I have a problem with one sheet within a workbook. The sheet seems to have
the scroll bar frozen and the Page down doesn't work properly. I have looked
under options but no joy.

Is there a disable option hidden away? Any help greatly appreciated

Kind regards

Rexmann


--

Dave Peterson



All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com