You cannot scroll to view the other areas of an Excel worksheet

Article translations Article translations
Article ID: 906309 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you try to scroll to view the other areas of a Microsoft Excel worksheet, the scrolling attempt is unsuccessful.

CAUSE

This issue may occur when the panes in the Excel worksheet have been frozen.

RESOLUTION

To resolve this issue, use one of the following methods, as appropriate for the version of Excel that you are running.

Microsoft Office Excel 2007

To unfreeze the panes in the Excel worksheet, click the View tab, click Freeze Panes in the Window group, and then click Unfreeze Panes.

Note If you want specific rows or columns to be visible when you scroll in the Excel worksheet, you must freeze those areas. To do this, scroll to the location that you want to be visible in the Excel worksheet, and then freeze the panes.

To freeze the panes in an Excel worksheet, click the View tab, click Freeze Panes in the Window group, and then click Freeze Panes.

Microsoft Office Excel 2003 and earlier versions of Excel

To unfreeze the panes in the Excel worksheet, click Unfreeze Panes on the Window menu.

Note If you want specific rows or columns to be visible when you scroll in the Excel worksheet, you must freeze those areas. To do this, scroll to the location that you want to be visible in the Excel worksheet, and then freeze the panes.

To freeze the panes in an Excel worksheet, click Freeze Panes on the Window menu.

Properties

Article ID: 906309 - Last Review: January 11, 2007 - Revision: 2.2
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbexpertisebeginner kbscrollbar kbtshoot kbprb KB906309

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com