MacXL: Cannot Change Scroll Lock Setting on Nonextended Keyboard

Article translations Article translations
Article ID: 118467 - View products that this article applies to.
This article was previously published under Q118467
Expand all | Collapse all

On This Page


If you are using a Macintosh that does not have an extended keyboard (such as a Macintosh PowerBook), you cannot use a key combination to change the Scroll Lock state. This article describes how to change this setting without using a key combination.


The information for the Scroll Lock state is stored in the Microsoft Excel Settings file.
  • If you are using Microsoft Excel X under Mac OS X, the Microsoft Excel Settings (10) file is located in the following folder:
    User's home folder/Library/Preferences/Microsoft
  • If you are using Microsoft Excel 2001 for Mac, the Microsoft Excel Settings (9) file is located in the following folder:
    System Folder:Preferences:Microsoft
  • If you are using System 7.0 or later and versions of Excel up to Excel 98, the Microsoft Excel Settings File is located in the Preferences folder inside the System folder; if you are using System 6.X, the Microsoft Excel Settings file is located at the root level of the System folder.

How to Change the Scroll Lock State Without Using a Key Combination

To change the Scroll Lock state, use any of the following methods.

Method 1

Press SHIFT+F14 to try to toggle the scroll lock state.

Method 2: Remove Your Microsoft Excel Settings File

Drag the Microsoft Excel Settings file to the trash. Although this method is easy, it causes all of your current Microsoft Excel settings to be lost.

Method 3: Attach an Extended Keyboard to Your Macintosh

  1. Shut down the Macintosh and connect a keyboard that has a SCROLL LOCK key.
  2. Restart the Macintosh and run Microsoft Excel.
  3. Quit Microsoft Excel and shut down the Macintosh.
  4. Disconnect the keyboard, connect the original keyboard, and restart your computer.

Method 4: Copy Your Settings File to a Macintosh That Has an Extended Keyboard

  1. Copy the Microsoft Excel Settings file to a Macintosh that has a SCROLL LOCK key.
  2. Start Microsoft Excel (click OK to dismiss the error messages that appear).
  3. Change the Scroll Lock state and copy the settings file back to the Macintosh that doesn't have an extended keyboard.


Article ID: 118467 - Last Review: January 19, 2007 - Revision: 1.1
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
  • Microsoft Excel 3.0 for Macintosh
  • Microsoft Excel 4.0 for Macintosh
  • Microsoft Excel 5.0 for Macintosh
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback


Contact us for more help

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