| Thread | Last Post | Replies |
|
| How to tell when text is too long for cell dimensions? | 03 Jan 2005 23:10 GMT | 1 |
I'd like to write a macro to deal with cells that do not have enough space to show the text they contain. Right now, Excel simply truncates the text at the right edge of the cell if the next cell to the right has anything in it. What I'd like to do is show the full text in a ...
|
| parsing cell data | 03 Jan 2005 22:47 GMT | 1 |
Here is my question: I have two cells, side by side on the same row. One has an amount in it, the other has a list of names, comma delimited. I need to transpose the names so that there is one row per name, with the amount next to it (same amount for each row). How can I
|
| converting lotus 123 files to excel | 03 Jan 2005 19:25 GMT | 6 |
How do I convet 123 files to excel ??
|
| Excel opens files very slowly | 03 Jan 2005 18:16 GMT | 3 |
I have an odd problem that is driving me nuts. Computer 1 has no problems with Excel Computer 2 has no problems with Excel Computer 3 is my problem. It opens all files, XLS, DBF, etc, extremely
|
| Margin/markup formula for Excel | 03 Jan 2005 18:01 GMT | 3 |
I am trying to insert a formula to calculate a percentage of margin/markup. Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is 10.00. Can anyone help with this formula?
|
| How do I find template with tiny squares on the entire page | 03 Jan 2005 17:54 GMT | 1 |
I am looking for a template to use in recording expenses. I think all I need is a sheet with small squares on the entire page - or columns. But, I want the lines already there so I don't have to draw them in. Is there something available like this? A template? Thanks....sorry ...
|
| external data and query | 03 Jan 2005 16:25 GMT | 17 |
i don't think this is possible but i would ask anyway if i have a field as part of an external table that i want to trim the record, is it possible through a query? for example, if a record was 25 characters in length and i only wanted the
|
| Newbie Question | 03 Jan 2005 15:04 GMT | 3 |
Sorry for this simple question I keep forgetting how to do it. When you enter data in a table and it is prefixed by letters E.g. : 103 kg or 210 lbs how do you enter it so you can perform calculation on the numbers? If I enter theses prefixes I cannot get Excel to recognise the ...
|
| Run SQL-Server Query in Excel | 03 Jan 2005 11:37 GMT | 5 |
is there a way to run a SQL-query on a SQL-Server within Excel? (Is it possible to create any JOIN-querys and DATEDIFF-functions within Excel-Microsoft Query?)
|
| Loop Code? | 03 Jan 2005 10:10 GMT | 5 |
I have a macro that when run changes the color of a row based on a cell value. Col A has TRUE & FALSE values and the color of the row changes whether TRUE or FALSE.
|
| Excel program not printing all pages... | 03 Jan 2005 09:05 GMT | 1 |
I have a program for work that is several pages in length. All of a sudden, I am only able to print the second of three pages. Before, I was able to hit print and the whole document printed. I didn't intentionally select cells/rows--so how did I get locked into this? I'm so ...
|
| make first few rows print on every page? | 03 Jan 2005 06:07 GMT | 3 |
I have the first few rows of my sheet frozen so that I can scroll down the long columns (about 3 printed page lengths) without losing sight of the top headings. I would like to be able to set it so that those top rows print at the top of
|
| Addtional Info on Lock Out | 03 Jan 2005 04:51 GMT | 1 |
I believe I accidently held the right shift key down for more than 8 seconds....I see it turns on filter options...I think I selected Ok the first time it came up but have no idea what it did. All I know is that whenever I mouse over any graphic object I get the circle with a ...
|
| combining text | 03 Jan 2005 03:43 GMT | 6 |
I have some thing like this.... Date Amount Notes 1 Jan 25 rain 1 Jan 33 sunny
|
| How do I activate the trial exel 2003 program if it does't find c. | 03 Jan 2005 02:19 GMT | 1 |
My Browser works good but the activation window does't find conection
|