Excel: Worksheet Scrolls When Arrow Keys Used (Scroll Lock)

 Last reviewed: November 29, 1994
Article ID: Q50153
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

SUMMARY

The Scroll Lock feature in Microsoft Excel versions 2.20, 3.00 and 4.00 allows you to use the arrow keys on the keyboard in the same manner as the arrows on the scroll bars. When Scroll Lock is turned on, using an arrow key on the keyboard scrolls the spreadsheet without moving the active cell. If Scroll Lock is disabled, pressing an arrow key on the keyboard scrolls you through the spreadsheet and moves the active cell accordingly.

Do the following to toggle the Scroll Lock function on and off:

  • On the Apple extended keyboard, press SHIFT+F14.
  • On an older DataDesk keyboard on a Macintosh Plus, press F12.
  • On the newest DataDesk keyboards, press either SHIFT+F14 or F14.

If Scroll Lock is turned on and you are using a standard Macintosh keyboard that does not have the function keys, the only way to turn Scroll Lock off is to remove the Excel Settings file in the System Folder and restart Excel. You cannot turn on Scroll Lock from a keyboard that does not have the function keys built into it.

NOTE: The DataDesk Keyboard is purchased separately from the dealer and does have functions keys. The standard Macintosh Plus Keyboard and the standard Apple Desktop Bus Keyboard (Standard ADB Keyboard) do not have function keys and cannot enable or disable scroll lock.

KBCategory: kbother
KBSubcategory:

Additional reference words: 2.20 3.00 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.