| Thread | Last Post | Replies |
|
| compressing an Excel file | 17 Dec 2005 13:36 GMT | 1 |
compressing an Excel file for faster emailing
|
| Drop down box font size | 17 Dec 2005 10:20 GMT | 2 |
XL 2004 (Mac) Drop down box font size appears to be same as font used in the sheet When the same workbook is opened in XL 2002 (Windows), the 12pt Arial in the sheet appears to be about 8pt in the drop down box
|
| Need help with a formula | 17 Dec 2005 09:38 GMT | 2 |
I need help setting up a formula. I have N observations (usually between 60 and 100 observations). I want to choose the observation that estimates the 95th percentile. Industry guidelines suggest that the observations be ranked and the 95th
|
| Excel VBA to be replaced by C# ? | 17 Dec 2005 09:35 GMT | 2 |
Are there any plans on ditching Excel/Office VBA and replacing with C# ? If so, then I suppose I'd better start getting prepared....
|
| Named Reference | 17 Dec 2005 08:20 GMT | 2 |
Can someone tell me what the pros and cons are (if any) of these 2 ways of naming a range. ActiveWorkbook.Names.Add NAME:="HOME", RefersTo:=ActiveCell Range("HOME").Select
|
| Saving | 17 Dec 2005 06:16 GMT | 1 |
Here's a good one, is there any way to save changes to a worksheet, but not the whole workbook? Any help would be greatly appriciated. Thanks.
|
| Justifying Text | 17 Dec 2005 06:12 GMT | 2 |
I'd like to be able to wrap a 2 word header, have the second (bottom) word right justified in the cell but the first (top) word centred above the second word. I can manage it by padding the first word with character colours matching
|
| How can I choose alternate rows in a column? | 17 Dec 2005 05:16 GMT | 2 |
My requirement is to be able to create a column whose elements consist of difference between adjacent elements in a column, say column A. If I can choose alternate elements and create 2 new columns then I can just subtract the 2 columns easily.
|
| Display row for presentation | 17 Dec 2005 05:14 GMT | 2 |
I sat in a meeting recently in which the meeting leader displayed a large spreadsheet on a projector connected to a laptop. Each row had 20 + columns. Is there a way to choose a row and display only that row in a format more suitable for presentation ?? Perhaps linking the cells ...
|
| 3 possible values | 17 Dec 2005 04:57 GMT | 5 |
=IF(F85>F84,"Winner","Loser")---- this is the formula that I'm currentl using, but if a value has not yet been entered into cells F85 or F84 i will still give me a Loser value. I understand why it is doing, but ho can I have it put N/A if both values after still empty? Hopefully
|
| Locking Formulas | 17 Dec 2005 02:19 GMT | 3 |
I need to average 3 cells. However, whenever I add a new column, the formulas shift by a cell, but I dont want them to. How do I keep the formulas from changing? Example:
|
| What is the cell data reference for 5th row and 7th column called | 17 Dec 2005 01:52 GMT | 1 |
Can someone help me with this question? I need to get the answer for my homework. Thanks for your help.
|
| unrecognized character | 17 Dec 2005 01:47 GMT | 3 |
I am trying to SEARCH or FIND a text string in an excel file without any luck. The character is a hyphen (-) and the excel function (see about) says it can't see it. 28(Sittin' on) the Dock of the Bay - Otis Redding (1968)
|
| It would be nice if....... | 17 Dec 2005 01:14 GMT | 9 |
somebody actually took the time to help people on this website.
|
| Read-Only won't go away. | 17 Dec 2005 01:09 GMT | 2 |
I've been working at this issue for some time now and all the advice I have tried has failed. Familiar problem: I attempt to open a excel file from my A: drive and of course it says,
|