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


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.