Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.


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.

↑ Back to the top


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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB213986, kbprb

↑ Back to the top

Article Info
Article ID : 213986
Revision : 5
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 36