Resizing a Drop-Down List

Summary: A great tip on getting your drop-down lists the size you want them. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Certain tools on the Excel toolbars require the use of drop-down lists. For instance, you can see several of these on the Formatting toolbar; they are used for font names and font sizes. As you customize Excel, you can change the size of these drop-down lists, if desired. Follow these steps:

Choose Customize from the Tools menu. Excel displays the Customize dialog box.
On your existing toolbars, click on the drop-down list whose size you want to adjust. A black selection box should appear around the list.
Point to the left or right border of the black border; click and hold down the mouse button.
Move the mouse left or right until the list box is the width you want.
Release the mouse button.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2489) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.

Check out ExcelTips: Filters and Filtering today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Resizing a Drop-Down List