Is it possible to increase the font size of drop down lists. The font is too small for legibility when faxed.
Changing font sizes in drop down lists,etc
2 posts
• Page 1 of 1
- 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?
Next
Changing font sizes in drop down lists,etc
by BillB » Sat, 12 Jun 2004 05:17:43 GMT
Re: Changing font sizes in drop down lists,etc
by Gord Dibben » Sat, 12 Jun 2004 07:08:47 GMT
Bill 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
Hi, 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. HTH >-----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 out. > >Thanks >. >
2.how 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
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 31 guest