| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change the font on auto filter?
Can I change the font size in an auto filter drop down?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change the font on auto filter?
Not without changing the worksheet Zoom setting.
Gord Dibben MS Excel MVP On Tue, 28 Jul 2009 04:08:01 -0700, CFI wrote: Can I change the font size in an auto filter drop down? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change the font on auto filter?
So one thing you can do to simulate increasing the auto filter font size:
Select the "Format/Style..." menu. Select the "Normal" style and click on the "Modify" button. Reduce the font size of the "Normal" font from 10 to (say) 6. This will change the default font size of everything (cells, column and row headers, etc). Now you will have to zoom up the view to make it readable again. Zoom up to 170%-200%. Then try the drop-down list - you will note that the font size is much larger. The "Normal" style does not seem to apply to the font size of the drop-down lists. HTH, Eric "Gord Dibben" wrote: Not without changing the worksheet Zoom setting. Gord Dibben MS Excel MVP On Tue, 28 Jul 2009 04:08:01 -0700, CFI wrote: Can I change the font size in an auto filter drop down? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto change font color in formula/cell | Excel Worksheet Functions | |||
| Auto change to Bold Font | Excel Discussion (Misc queries) | |||
| How do I change the color of the auto filter on/off icon? | Excel Discussion (Misc queries) | |||
| change chart title with auto filter | Charts and Charting in Excel | |||
| Auto change font to 'capital letters' | Excel Worksheet Functions | |||
Linear Mode
