|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 10th, 2006, 08:40 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
Font Size in Drop Down List
I have a drop down list where I want to change the Font Size. I have tried
changed it in the cells where the data resides and also in the cells where you have the drop down list and neither way increase the Font Size. I am sure it is something very simple that I am forgetting. Hope someone has the answer. 
|
|
#2
July 10th, 2006, 10:54 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Font Size in Drop Down List
Mindie
What type of drop-down list? Data Validation? Font size cannot be changed although you can use Zoom to make the whole sheet larger. See Debra Dalgleish's site for workarounds. http://www.contextures.on.ca/xlDataVal08.html#Font Gord Dibben MS Excel MVP On Mon, 10 Jul 2006 12:40:02 -0700, Mindie wrote: I have a drop down list where I want to change the Font Size. I have tried changed it in the cells where the data resides and also in the cells where you have the drop down list and neither way increase the Font Size. I am sure it is something very simple that I am forgetting. Hope someone has the answer.
|
|
#3
July 10th, 2006, 11:04 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Font Size in Drop Down List
Yes it is Data Validation. Problem is that I do not want to change the whole
sheet, just what is in the drop-down list. "Gord Dibben" wrote: Mindie What type of drop-down list? Data Validation? Font size cannot be changed although you can use Zoom to make the whole sheet larger. See Debra Dalgleish's site for workarounds. http://www.contextures.on.ca/xlDataVal08.html#Font Gord Dibben MS Excel MVP On Mon, 10 Jul 2006 12:40:02 -0700, Mindie wrote: I have a drop down list where I want to change the Font Size. I have tried changed it in the cells where the data resides and also in the cells where you have the drop down list and neither way increase the Font Size. I am sure it is something very simple that I am forgetting. Hope someone has the answer.
|
|
#4
July 10th, 2006, 11:40 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Font Size in Drop Down List
Then you will have to go the Combo-box route.
Did you check out Debra's site? I'll direct you to another of her pages which shows how to use a Combo-box. Note:VBA coding required with this method. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Mon, 10 Jul 2006 15:04:01 -0700, Mindie wrote: Yes it is Data Validation. Problem is that I do not want to change the whole sheet, just what is in the drop-down list. "Gord Dibben" wrote: Mindie What type of drop-down list? Data Validation? Font size cannot be changed although you can use Zoom to make the whole sheet larger. See Debra Dalgleish's site for workarounds. http://www.contextures.on.ca/xlDataVal08.html#Font Gord Dibben MS Excel MVP On Mon, 10 Jul 2006 12:40:02 -0700, Mindie wrote: I have a drop down list where I want to change the Font Size. I have tried changed it in the cells where the data resides and also in the cells where you have the drop down list and neither way increase the Font Size. I am sure it is something very simple that I am forgetting. Hope someone has the answer.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I created a monster | Ben | Running & Setting Up Queries | 2 | March 16th, 2006 02:43 PM |
| Font size in a dropdown list | Ant | General Discussion | 3 | November 3rd, 2005 02:21 PM |
| font size in a drop down list | kennedy | General Discussion | 1 | June 29th, 2005 11:13 PM |
| How do I change the font size of my "Folder List"? | FolderList Help | General Discussion | 1 | May 25th, 2005 05:01 PM |
| Font size for in-cell drop-down list | John Simons | Worksheet Functions | 4 | February 15th, 2005 08:03 AM |
Linear Mode
