Changing font sizes in drop down lists,etc



  • 1. Totalling sequential worksheets
    I want to set up a generic formula that automatically looks for a particular cell in the previous worksheet & adds 1 to the value. When I copy & paste the formula, it copies exactly, instead up updating to the previous worksheet, even when I try copying only the formatting or formula. Example: In worksheet January 13, 2008, the formula is: =SUM('Dec 9, 2008'!M2+1) & the value is 7 In the worksheet February 10, the formula is: =SUM('Jan 13, 2008'!M2+1) and the value is 8 When I create the new worksheet March 10, 2009, I copy the cell from the February worksheet & paste it into the March work sheet, it comes out as: =SUM('Jan 13, 2008'!M2+1) with a value of 8 I want it to come out as: =SUM('Feb 10, 2009'!M2+1) with a value of 9. And so on.... so each total value in cell M2 gets greater in increments of 1, & that it calculates it without me having to create the formula for that cell each time - because there are approximately 25 cells in each worksheet that need to be updated in this way. Anybody got a clue? Thanks!
  • 2. VLOOKUP ?
    I just purchased Excel 2003 and was reworking my spreadsheet from Works I use this formula in Works, =VLOOKUP(L4,$J$53:$K$104,1 It works fine there but dosen't work with Excel 2003
  • 3. two-dimensional frequency question
    i have another peculiar question. Say you have the following data: A C B D B D B E A C B E A E B D B E A C B D and you want to count how many times an "A C" is followed by a "B D," and how many. So, output for the above would be: 1: 1 2: 1 i think the way to do it would be to sum over a frequency, but i can't figure out how to set the bin array the way i need it. the bins would have to start at "A C" and reset after any "A <>C" thoughts? maybe a way to do it that way or a better way entirely?
  • 4. Search Function
    i am using a search function to evaluate a cell and return a 0 or a 1 depending on whether the text is found. The syntax used is as follows: =if(SEARCH("White",J2)>0,1,0) so i am searching a field with the word white and if it exists it will return a value that is greater than 0 and a 1 will be placed in the cell. This part works great and returns the desired result. If however the word White does not exist in the cello J2, the result is #VALUE! not 0. I tried to trap on #VALUE! to no avail. I tried to return the value of the search, the answer is the same. I tried testing on Null or ISNull to no avail. Do you have any ideas?

Changing font sizes in drop down lists,etc

Postby BillB » Sat, 12 Jun 2004 05:17:43 GMT

Is it possible to increase the font size of drop down 
lists.  The font is too small for legibility when faxed.

Re: Changing font sizes in drop down lists,etc

Postby Gord Dibben » Sat, 12 Jun 2004 07:08:47 GMT


If you're talking about Data Validation drop-down lists, see Debra Dalgleish's
site for work-arounds.

 http://www.**--****.com/ #Larger

Gord Dibben Excel MVP

On Thu, 10 Jun 2004 13:17:43 -0700, "BillB"

Similar Threads:

1.Drop down list - Changing font size

Using your Control Toolbox, go into the design mode, right 
click on the combo box, go to properties, Select the 
Categorized Tab, find Font and click on the box to the 
right of the font name (it has 3 dots ...).  From there 
you will be able to select the font, size etc.


>-----Original Message-----
>I created several combo drop down lists in a couple of 
spreadsheets and can not figure out how to format the font 
within the drop down list. Can anyone help me figure this 
> do i change the font size on drop down cell validation lists

I want to cahange the font size on my drop down cells. I can't find a way to 
do that in excel or thruogh visual basic. It is easier to read the workbook 
at 75%, but, when I do that, the drop down cells(data validation list) are 
too small to read.Help!!

3.Change Font Size in Drop Down List

How can I change the Font Size of the items in a drop down list I created in 
a Cell in my spreadsheet.  

4.Change font size in drop down validation lists

Is there a way to change the font size in the validation drop down list, as 
on some spreedsheets it is almost unreadable

5.Change the font size of a list in a drop down

How can I change the font size of a list in a drop down?

6. Changing font size in data validation drop-down lists

7. font size in a drop down list

8. Font size in data validation drop down lists

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 31 guest