ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make the drop down list view larger? (https://www.excelbanter.com/excel-discussion-misc-queries/265158-how-do-i-make-drop-down-list-view-larger.html)

John

How do I make the drop down list view larger?
 


steve

How do I make the drop down list view larger?
 
Hi,

Select the cell that has your list and choose a different font size

Regards
Steve
"John" wrote in message
...




Pete_UK

How do I make the drop down list view larger?
 
Debra Dalgleish has some techniques he

http://www.contextures.com/xlDataVal08.html#Larger

Hope this helps.

Pete

On Jun 3, 5:03*pm, John wrote:



Gord Dibben

How do I make the drop down list view larger?
 
Steve

If OP is referring to Data Validation dropdown list there is no font
changing.

8 pt is the only size you get.


Gord Dibben MS Excel MVP

On Thu, 3 Jun 2010 17:09:30 +0100, "steve" wrote:

Hi,

Select the cell that has your list and choose a different font size

Regards
Steve
"John" wrote in message
...




steve

How do I make the drop down list view larger?
 
Yes, sorry about that, momentary lapse. You can alter the font in the cell
once it has been selected. But the drop down list itself remains at 8pt

Regards
Steve
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Steve

If OP is referring to Data Validation dropdown list there is no font
changing.

8 pt is the only size you get.


Gord Dibben MS Excel MVP

On Thu, 3 Jun 2010 17:09:30 +0100, "steve" wrote:

Hi,

Select the cell that has your list and choose a different font size

Regards
Steve
"John" wrote in message
...






All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com