| Thread | Last Post | Replies |
|
| Conditional Formatting referencing other Worksheets | 18 Dec 2006 23:26 GMT | 1 |
I sometimes get lost with too much formula-ese, so please forgive me if the answer is clearly out there. First, let me state that I understand that when a cell is linked, just the value, not the format travels with it.
|
| Unwanted Autoshapes ... | 18 Dec 2006 22:58 GMT | 3 |
For some strange reason, I have thousands of autoshapes in my worksheet. I neither want or need them, is there any way I can delete all of them without compromising my worksheet. My file jumped from 1.2 mb to 25.3 mb. Any help would greatly be appreciated.
|
| Making a cell blank or empty without deleting it | 18 Dec 2006 22:44 GMT | 1 |
Hopefully I explain this well: I have data logged over a few days. It is simply stored as two columns of equal length. (Temp and pressure) I am performing a test on the pressure reading using an IF statement in
|
| Format 2 colors | 18 Dec 2006 21:53 GMT | 6 |
Using Formula =IF(T1399>2000000,"Heavy","Normal"), with conditional formatting I can color Heavy when it pertains, but I cannot color Normal when it applies. How can I have two colors depending on the True or False of the formula?
|
| merge 5 excel files | 18 Dec 2006 18:20 GMT | 1 |
Hello NG I have a question, can I merge excel files? the excel files has the sam format only other data. thanks for the answers.
|
| locate referenced cells | 18 Dec 2006 17:49 GMT | 1 |
I have a spread sheet that when opening gives the message that cells are referencing other work sheet cells. I am having trouble finding which cells has the reference. Is there a easy way to locate these cells?
|
| Hide unhide sheets | 18 Dec 2006 14:38 GMT | 2 |
Hello Excellers, With a value in cel B23 on every sheet i want to hide or unhide the sheets. Standard they are hidden when i start. Who can help me with a procedure for this pls?
|
| macro not working | 18 Dec 2006 14:05 GMT | 5 |
I've contacted this group before but was unable to folow through. I have a macro on a spreadsheet made on excel 2000. I have a virus protection program. Is there any way I can send my spreadsheet to someone and have the macro fixed?
|
| A Macro Question | 18 Dec 2006 09:44 GMT | 2 |
I have a large Excel file that downloads and does some calculating. It takes about a hour and a half for this to complete. Most of the time is the calculating. This must be done early Monday mornings but the file is completed by another dept on Sunday afternoons. There is a Macro
|
| Counting Within a Cell | 18 Dec 2006 09:14 GMT | 2 |
How do I count the number of digits within a cell. 4,5,6,7 The answer should be four. I don't want to count the commas. Thanks,
|
| Formula Question | 17 Dec 2006 23:06 GMT | 1 |
I'm working on a spreadsheet that will keep track of Exacta, trifecta and superfecta bets for a handicapping contest. Let's just start with the exacta. Is it possible to enter data like the following and to come up with a
|
| How do I become a developer? | 17 Dec 2006 20:45 GMT | 3 |
How do I become a developer?
|
| New Drop-down lists failing | 17 Dec 2006 16:41 GMT | 1 |
Hi, I'm working on Excel 2003, in a workbook with macros, radio buttons etc. I've been trying to add a drop-down list using Data>Validation. The validation info gets registered (only the data entered is a valid input) but the drop-down list is not displayed (no arrow). Performing
|
| CountIF function | 17 Dec 2006 16:01 GMT | 1 |
I wonder how possible it is to count the number of cells with a date depending on the result of another cell in the same row without using a Pivot Table. Ie, If I wanted to count the number of times Bread was delivered on
|
| Excel 2003 colour | 17 Dec 2006 14:08 GMT | 2 |
I have the following problem with Excel I have seen that a simila question was asked some 18 months ago but am unable to find th solution I am using Office 2003 Pro and my Excel 2003 will not "fill" cells wit
|