| Thread | Last Post | Replies |
|
| Unable to unmerge/merge cells | 06 Dec 2005 15:14 GMT | 4 |
Hi all, excel 2k2; I have a row of data, the first two columns are merged(row 2 and row 3) then the next n columns are "normal" cells. I can not merge any of these cells to match the first two.(I just want to merge row 2 and 3 in
|
| Changing the colour of a comment? | 06 Dec 2005 14:51 GMT | 3 |
I want to know in Excel 2003, when I enter in a comment the cell is flagged with a red indicator in the top right hand corner. Is there a way that I can change the colour of the indicator? Thanks
|
| how to use short cuts when making stock list | 06 Dec 2005 14:47 GMT | 2 |
when i'm making list for my stocks or check list of avaibilty of my client & service providers how do i use the short cut like phrases
|
| X=1 Help!!! | 06 Dec 2005 14:27 GMT | 4 |
I have a spreadsheet where I have a cell (P1) NAMED "Free". In the following range ($P$2:$P$65536) - I will be using X, or x to indicate it's free of charge. I want this to be equal to 1. The formula that I am using is ----- =SUMPRODUCT('[MyRecord Log
|
| Pivot table question | 06 Dec 2005 12:00 GMT | 2 |
I have the following pivot table : Continent Country Sales __________________________ Europe France 100
|
| excel 2002 wont accept my code on back of disk | 06 Dec 2005 11:56 GMT | 1 |
I cant use my microsoft office teachers addition because the program says the code isnt right. I redid it several times and still wont work. Is there something im doing wrong ? Need to use asap
|
| Can excel handle more than 256 columns? | 06 Dec 2005 11:29 GMT | 1 |
Hello there. Im new in this forum and came specifically for thi question. Im having trouble handling massive amounts of data, and i discovere that even tho excel can handle 65k lines, it haves a limit of mere 25
|
| xl file running slow | 06 Dec 2005 11:24 GMT | 1 |
Dear Excel Masters, I have a problem in 1 excel file (other files are ok), when ever i excecute any function or action ( copy / cut / paste / edit...etc..) it takes long time to come back to ready mode, file is also not big,
|
| hyperlink | 06 Dec 2005 09:11 GMT | 4 |
Hi, I am a newbie,please help. I created a hyperlink to jump from cell a1 to n1 on sheet1, I copied this link to sheet2, it will work the same on sheet2, however when I modified the cell address on this hyperlink, it will only work on
|
| Low system resources message when opening Excel | 06 Dec 2005 08:36 GMT | 4 |
I get the above message whenever I open Excel. Rebooting makes no difference. I have stopped all unnecessary background tasks but still get the above message. I have uninstalled and reinstalled Excel with no effect. Everything else on the machine works fine, I only get a
|
| question driving me nuts | 06 Dec 2005 05:35 GMT | 4 |
Okay...I never thought I would ever have to use excel again. Lo and behold, I am now the owner of a business and have forgotten how to do some things. I know how to create formaulas for adding and stuff. I forgot how to make my calculatons so that my deposit would be broken down. ...
|
| How to merge rows of data in 2 columns into 1 col. | 06 Dec 2005 05:29 GMT | 1 |
I have 199 rolws of data in 2 cols and want to merge it into one col. for printing lables. Excels instructions tell only how to merge 1 row, 2 cols into 1 col. How do I do this?
|
| Excel Named Formula Weakly Interacts with a Variable Range on the Worksheet | 06 Dec 2005 04:21 GMT | 6 |
1. An Excel Named Formula incorporates a worksheet range say, $A$1:$A$60, as a part of the formula. 2. When the given range on the worksheet expands by virtue of inserting rows thereof (such that $A$1:$A$60 becomes $A$1:$A$70), all the
|
| COPYING FILES | 06 Dec 2005 03:59 GMT | 2 |
dear friends... i want your help in this regard.... i want to copy some files from B:\ (map drive) to D:\ (local drive)... i dont want copy only the file which is yesturday modified/or new file.
|
| What does ^ do!? | 06 Dec 2005 01:56 GMT | 3 |
My knowledge of excel is pretty basic and i can't find any useful help anywhere. I'm trying to port a financial calculator written in excel to flash. One of the calculations in excel is =(1+J5)^(1/12)-1
|