XL: Unable to Use Scroll Bar on Number Tab in Format Cells Dialog Box (213986)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 2002
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
  • Microsoft Excel 2001 for Mac
This article was previously published under Q213986

SYMPTOMS

In Microsoft Excel, when you display the Format Cells dialog box and click the Number tab, the scroll bar in the Category list may be unavailable (dimmed). In addition, when you click an item in the Category list, different lists appear in the Format Cells dialog box; these lists may contain scroll bars that are not available.

CAUSE

This behavior can occur when you can see all the items in the list and it is not necessary to use the scroll bar.

NOTE: The scroll bar is visible for each of the lists.

MORE INFORMATION

The lists that appear when you click Date, Time, Fraction, or Special in the Category list may contain a greater number of items in localized versions of Excel. Therefore, you must use the scroll bar to access these lists. This is true even if you cannot use the scroll bar in the U.S. version of Excel.
Modification Type:MinorLast Reviewed:8/18/2005
Keywords:kbprb KB213986
©2004 Microsoft Corporation. All rights reserved.