| Thread | Last Post | Replies |
|
| How do I make all columns resize to | 13 Apr 2004 14:21 GMT | 2 |
Thanks again for the super smart folks in this place, that have pulled me out of a few sticky situations Got a new one today.. I have about 6 columns in my sheet. I want to be able to resize the first column on my JAN sheet, and the changes reflect on all of the following months. ...
|
| Help with Function | 13 Apr 2004 14:16 GMT | 1 |
I have a list in my spreadsheet which is extracted from a database and I need to look up values in this list. The value to lookup may, or may not be in this list. What I need is a method to report that the value does not exist, and if it does exist it must return the required info.
|
| word wrapping the entire column on every sheet in the book? | 13 Apr 2004 13:46 GMT | 2 |
I would also Like to have word-wrap on every cell in column B, on every sheet. Can I do this in one or two simple steps, rather than going to each sheet, and using the FORMAT CELLS option?
|
| Mileage record Template | 13 Apr 2004 13:05 GMT | 3 |
Anyone know where I can find a Mileage Record template for Excel. Something to keep track of mileage, gasoline amounts, etc? Thanking you so much for any help.
|
| Excel not opening files from file icon | 13 Apr 2004 11:55 GMT | 4 |
when I try to open a file double clicking on it or on a link to it, Excel program window opens but the file does not. If I try to open the file from Excel menu "File" -> "Open..." the file opens correctly.
|
| Special Characters | 13 Apr 2004 08:53 GMT | 1 |
I looking to find out if it is possible to use special characters i Excel msgbox's. Mainly the copyright and TM symbols. I tried the mos obvious method I could think of by copying and pasting them in fro word but that failed misserably!
|
| Linking cells in worksheets | 13 Apr 2004 02:48 GMT | 4 |
I have seen it where you can double click a link in a worksheet to another worksheet in the same Workbook and it opens the worksheet that is being referenced. eg. in sheet one there is a value in cell a1 that is
|
| Hide rows with zero value? | 13 Apr 2004 01:59 GMT | 18 |
just wondering how I would be able to hide rows on sheets if some cells are blank? the cells contain formulas they are only blank because `zero values` in >tools>options>view is unchecked. I have a sheet set up to SUMIF values from about 16 other sheets, and it
|
| Slow Menus and screen flickers | 13 Apr 2004 00:44 GMT | 2 |
I fired up my PC today and all of the Office Apps (version 2003) are suffering from very slow menus. The menus are slowly appearing from an opaque ghosted image to the full menu. This all takes a couple of seconds and is very annoying. This only happens with the Office apps ( ...
|
| matching columns of numbers | 12 Apr 2004 23:22 GMT | 3 |
In EXCEL 2000 for Windows, I have two columns of numbers. Column A has 500 numbers, Column B has 1000 numbers. I need to know which cells in Column A have a match in Column B, and if so, what is the Cell (or row number) in B that matches to that particular cell in A. How can I ...
|
| how to Hide rows? if cells are blank? | 12 Apr 2004 23:17 GMT | 14 |
just wondering how I would be able to hide rows on sheets if some cells are blank. I have a sheet set up to SUMIF values from about 16 other sheets, and it returns the values depending on 72 corresponding codes, I would like to hide
|
| Sorting multidimensional tables/multiple selections | 12 Apr 2004 23:06 GMT | 1 |
I have several big matrices (1200*50) on different worksheets. It is a time-series data, so row headings are dates and column headings are firms. Cells are stock earnings, every worksheet using a different principle for calculating them.
|
| Displaying totals of calculated fields in Pivot tables/charts | 12 Apr 2004 22:45 GMT | 1 |
I find that, when I create a Pivot table, I can only derive totals for those items that have been entered by hand - wnen I try to get totals of calculated fields, I only get the count of occurrences of those fields
|
| Report Manager add-in on excel 2003 | 12 Apr 2004 22:37 GMT | 5 |
Hi, I tried to install add-in Report Manager but only I found it fo excel 2002. I wanted install for excel 2003 but it doesn?t work. Does somebody knows if exist this add-in for excel 03 ?
|
| VBA populate combobox probelm | 12 Apr 2004 22:23 GMT | 2 |
Hi, What i would like to do is to populate a combobox from the value o another combobox. The user would select a state from one combobox an the next combobox would contain values of names of people from tha
|