| Thread | Last Post | Replies |
|
| 2 monitors - Excel 97 | 19 Sep 2006 21:33 GMT | 6 |
I can stretch Excel 97 across 2 monitors, but worksheets can't seem to stretch any larger than 1 monitor wide.
|
| Excel Appearance | 19 Sep 2006 21:22 GMT | 2 |
All of the sudden, I saw that the letters at the top of the columns now are change to numbers. Now I see numbers for rows and columns. How can I change the Excel appearance, so I see the letters at the top of the columns again?
|
| Conditional Array Formula for date | 19 Sep 2006 21:05 GMT | 5 |
I am trying to display all the dates for a particular month from a list. The data is accumulated on the Log sheet and is pulled to the Monthly Log sheet based on a dropdown. =INDEX(Log!$A$1:$O$2000,SMALL(IF((Log!$B$1:$B$2000<($Q$1),
|
| enter consecutive cells into a formula | 19 Sep 2006 20:46 GMT | 2 |
I am trying to find a folrmula that will enable me to get the data in consecutive cells, but the cell numbering changes every time, I am using the Vlookup function to find the info in the first cell, but the other cells dont have a V or an H lookup possiblility. What I'm trying ...
|
| All Excel Dates show as 2006 | 19 Sep 2006 20:39 GMT | 5 |
All my dates are showing as 2006. Even when I type 2003 or 2004, they come in as 2006. What is causing this problem?
|
| Taking infomation in one sheet and adding it to another sheet | 19 Sep 2006 20:37 GMT | 1 |
I have two sheets. First sheets has the heading Homeroom and then the teachers name next too it assigning one homeroom to that teacher. In my next sheet I have homerooms and teacher again but this time I have the same homeroom mulitple times. Another words Sheet 1 would have ...
|
| freeze font size in excel. | 19 Sep 2006 20:31 GMT | 1 |
I have set 14 as font size in "format cells" drop down. Right size font is printed, but it reverts back to 7.5 as soon as I leave cell. Note: I'm trying to add e-mail addresses in a column after a list of friends
|
| creating a pdf | 19 Sep 2006 20:21 GMT | 4 |
when creating a PDF from excel with 3 worksheets the 3rd worksheet comes out blank. I also add a compamy logo at the top of the three woorsheets in a jpeg format but it keeps getting cut off. Earlier vervions of excel didn't produce these problems.
|
| Protection on excel file | 19 Sep 2006 20:06 GMT | 4 |
To the 'community' Is it possible to protect a formula and still have it update the calculation when others add to the database? Thanks ahead for your help...
|
| How do I make colors appear correctly when linking excel to pub? | 19 Sep 2006 19:52 GMT | 3 |
Hi, when I link an excel table to a publisher document (for a client report), the number that are in red in the excel spread sheet appear red in the publisher document, until I print it. Then, the number appear black. Why? Thank you -- any help would be greatly appreciated!
|
| data validation - more than one in same cell? | 19 Sep 2006 19:31 GMT | 2 |
I have set up data validation to ensure number is = or > 3,000. Otherwise an error box shows up with a message. However, I want to have another error if the number is = or > 1,000,000 with a different message. Is this possible? Thanks.
|
| Using data form in large mailing list spreadsheet | 19 Sep 2006 19:28 GMT | 1 |
I have a large mailing list in EXCEL 2003 that I am updating and adding to on a regular basis. I am also doing registration for an event using this spreadsheet which has many columns. When I use the data form I am limited to 32 columns, which so far means I have to hide some of ...
|
| Ms Query problem | 19 Sep 2006 19:25 GMT | 2 |
Sometimes when using MS Query, I can select multiple datafiles to construct my quuery with, but sometimes that is greyed out. Why?? Oh, I also notice that when the "Add Workbooks" is greyed out, the file that I am conected to places a dollar sign chaacter after the shet name, ...
|
| How do I change the AUTOMATIC color in Excel for the font? | 19 Sep 2006 19:18 GMT | 1 |
When I first got excel I changed my automatic color for the font. I would like to change it again and I cannot remember how to do it. Does anyone have any answers for me? Thank you......
|
| Adding to an exsisting formula | 19 Sep 2006 18:46 GMT | 2 |
I need to know if or how I can add to an exsisting formula. I have currently =SUMA1+B1 I need to add =INT(A1)+ROUND(MOD(A1,1)*100/60,2)
|