| Thread | Last Post | Replies |
|
| Help formatting text color based on formula | 11 Feb 2006 00:54 GMT | 1 |
I have searched the forum and find some things that help but not quite enough. I have a table of numbers. In fact there are 300 rows of 5 colums of numbers. What I would like to do is to change the color of the number if it matches one of 5 other numbers.
|
| Find Column Reference Number | 11 Feb 2006 00:25 GMT | 2 |
I receive an Excel tab with headers. The header is always the same exept for the order. I mean, let's say I have the header : Name , Unit, Company Those three will always be there but in different order.
|
| Excel 2000 Drop Down Menu | 10 Feb 2006 23:57 GMT | 2 |
I have seen a drop down menu before in an Excel cell. I would like to incorporate this feature to be used for selecting a month of the year. How do I go about creating such a feature?
|
| Histogram Plot | 10 Feb 2006 23:30 GMT | 1 |
Hello fellow Excel users, When trying to do a histogram plot I receive the following error message: "Cannot change part of a merged cell" and then "Histogram - Cannot draw chart for empty bins"
|
| update cell without saving | 10 Feb 2006 23:13 GMT | 2 |
I have a real beginner question. I have an excel 97 spreadsheet that won't update the results cell for a simple SUM function without saving the spreadsheet. Can I change that ?
|
| How do I reset the automatic outline for subtotals | 10 Feb 2006 23:03 GMT | 1 |
When I create subtotal levels, I do not automatically see outline or grouping. What have I turned off?
|
| Masking? | 10 Feb 2006 22:22 GMT | 1 |
I would like to do some data entry in a spread sheet. First example I have a date cell and it is using the standard of 02/07/06 . I want to make it so that when I start the cell I see the slashes and I
|
| Undo current sheet | 10 Feb 2006 22:20 GMT | 1 |
Hi again. Don't know how to explain this. I'm working on a couple of Excel files at the same time, going from one to the other.
|
| Excel 2002 can't open Excel 97 properly ? | 10 Feb 2006 22:19 GMT | 1 |
I am using Excel 2002. If I open an Excel 97 spreadsheet, I get the error below : Renamed invalid sheet name The new sheet name is then "Recovered_Sheet1
|
| Pivot table experts: using sums instead of counts in repeated columns | 10 Feb 2006 22:11 GMT | 1 |
Pivot table experts, I can't seem to make this work. First field is dragged to "row fields" and correctly becomes my first column. Second and subsequent fields are the same kind of field and are supposed to
|
| External reference with variable workbook name? | 10 Feb 2006 21:48 GMT | 4 |
I'm referencing an external workbook and need part of the workbook name to be a variable. My base formula is; [55421GNTForms.xls]SBR'!$C$5 I need "55421" to be a variable, with the new information pulled from a cell within the referencing workbook. (55421 is a name, not a ...
|
| Latest Modification Date Automatically Printed | 10 Feb 2006 19:56 GMT | 1 |
I am new to Excel and I have a pretty elementary question that I could not find an answer for. I want to indicate on the Excel spreadsheet when it prints out the last date I have modified the spreadsheet. I would like to have that printed out automatically, without my having to ...
|
| Excel 2000 large files losing formulars... | 10 Feb 2006 19:44 GMT | 9 |
Ok, this is a serious issue. In our accounting department we're using Excel 2000, but on some files (25k -63k) from time to time it would lose the formulas or we'd get an error when we try to save, "not enough memory" We're on Win2K, 1GB memory. But, does anyone know how to ...
|
| FIND and REPLACE characters needed | 10 Feb 2006 19:09 GMT | 2 |
What characters (~, #, ?) do I use to Find and Replace item cells of first following row with second row below? FIND these types, eg: =(DSUM(DIVOH,$CX$1,$DG$2:$DG$20) Replace with these types, eg:
|
| Simple Stock Control Sheet | 10 Feb 2006 18:33 GMT | 1 |
Im Trying To Write A Simple Sheet That Basicly Lists All The Components In Stock With There Quantities, And Then Have A Cell Dedicated To Selecting A Component And Entering A Quantity That Has Been Removed From The Total Individual Amount.i.e
|