Microsoft KB Archive/906309

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

Article ID: 906309

Article Last Modified on 1/11/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



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.

Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12 excel2003 excel2k3 xl2003 xl2k3 excel2002 excel2k2 excelxp xl2002 xl2k2 xlxp excel2000 excel2k xl2000 xl2k

Keywords: kbexpertisebeginner kbscrollbar kbtshoot kbprb KB906309

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.