How to expand width of name/reference area in formula bar

Chris Kinata · Aug 12, 2005

Hi all...

Does anyone know how to increase the width of the
dropdown at the left end of the formula bar that displays
the current reference and named ranges?

Regards,
Chris

Chip Pearson · Aug 12, 2005

See http://www.cpearson.com/excel/NameBox.htm for example code to
do this. The code will expand the width of the dropdown when it
is dropped down, not as it is displayed on the formula bar.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Chris Kinata · Aug 12, 2005

Hi Chip,

Wow. You are like totally awesome!

Thanks!
Chris

Chip Pearson · Aug 12, 2005

I have my moments.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Increase width of cell names in formula bar	1	May 31, 2005
Width of Active Cell Name drop down combo list	6	Nov 14, 2007
Formulas do not link to other workbooks	4	Jun 28, 2010
How to reference workbook name in hyperlink formula?	1	Sep 23, 2010
Changing column reference for number of formulas at once	1	Nov 18, 2013
Shortcut to navigate from Formula Bar (?)	5	Feb 21, 2004
Create Correct Formula	10	Nov 27, 2008
how to add error bars into bar chart	1	Dec 6, 2011

How to expand width of name/reference area in formula bar

Chris Kinata

Chip Pearson

Chris Kinata

Chip Pearson

Ask a Question

Similar Threads