MacXL: Cannot Change Scroll Lock Setting on Nonextended Keyboard

This article was previously published under Q118467
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.
SUMMARY
If you are using a Macintosh that does not have an extended keyboard (suchas 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.
MORE INFORMATION
The information for the Scroll Lock state is stored in the Microsoft ExcelSettings 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.
MacXLX Mac XLX XL2001 XL98 4.00 PLUS SE scroll-lock
Properties

Article ID: 118467 - Last Review: 01/19/2007 04:52:40 - 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

  • KB118467
Feedback