Scroll problem


L

Lawman

I use Excel 2002 SP3

One of the worksheets in a workbook that comprises several worksheets will
no longer scroll vertically. In other words, when I use the mouse wheel,
slide vertical scroll bar or cursor up and down the sheet with an arrow
button, the sheet view remains static (though the scroll bar moves, the
selected cell appears in the Name box changes and the contents of the cell
are displayed in the formula bar).

Applying a filter still displays the selected rows.

The other worksheets in the workbook are unaffected.

Have I inadvertently altered a sheet property? How can I restore the
scrolling please?

Thanks in anticipation

Howard
 
Ad

Advertisements

Ad

Advertisements

L

Lawman

Why don't I think of the obvious first!

Thanks

L
| Howard,
|
| Sounds like Freeze Panes may be set.
| --
| http://HelpExcel.com
| (e-mail address removed)
|
|
|
| "Lawman" wrote:
|
| > I use Excel 2002 SP3
| >
| > One of the worksheets in a workbook that comprises several worksheets
will
| > no longer scroll vertically. In other words, when I use the mouse wheel,
| > slide vertical scroll bar or cursor up and down the sheet with an arrow
| > button, the sheet view remains static (though the scroll bar moves, the
| > selected cell appears in the Name box changes and the contents of the
cell
| > are displayed in the formula bar).
| >
| > Applying a filter still displays the selected rows.
| >
| > The other worksheets in the workbook are unaffected.
| >
| > Have I inadvertently altered a sheet property? How can I restore the
| > scrolling please?
| >
| > Thanks in anticipation
| >
| > Howard
| >
| >
| >
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top