| Thread | Last Post | Replies |
|
| Hyperlink Question | 20 Aug 2008 09:25 GMT | 1 |
Can someone please help tell me how do I set a hyper link from a picture/object in excel to a certain page in powerpoint. Thanks and Regards Michael Lew
|
| Displaying Excell like a power point presentation | 20 Aug 2008 09:05 GMT | 3 |
Can this be done? The reason i need to know is i will be giving a presentation where i must have an open excell file that i can change, remove or add numbers on the fly. I have a projector that can accomodate me, but want to know if there is a way to remove all of the tabs and ...
|
| Protection & Locked issue | 20 Aug 2008 08:30 GMT | 1 |
Hi; I would appreciate if someone could help me with the following: I've a protected excel templates that contain some locked cells as well as unlocked cells. It works well at my end. But, after i distribute it to the
|
| to extract numeric figures in left side od the alpha charectors pl | 20 Aug 2008 08:29 GMT | 1 |
Hai all I have an excel sheet with the following structure Code 123445PPSS4
|
| Excel file sending an e-mail, is possible? | 20 Aug 2008 07:16 GMT | 14 |
Is it possible excel send out an e-mail when certain conditions are met?
|
| "IF" function question | 20 Aug 2008 06:30 GMT | 5 |
I have an IF function comparing 2 cells and it is under column C: A B C cat Dog "=if(A1=B1,1,0)" (here result is 0) Dog bird "=if(A2=B2,1,0)" (here result is 0)
|
| amend formula | 20 Aug 2008 05:02 GMT | 1 |
does anyone know what the curly brackets are and how to amend this formula as I get an error message {=SUM((G23:G30-H23:H30)^2)*1000}
|
| Used drawing colors in shapes....lost default colors for "Fill Col | 20 Aug 2008 04:45 GMT | 1 |
I had used autoshapes on my spreadsheet and used the "line colors" in "DRAWING". Somehow I now lost my default "Fill Color" and "Font Color" on the toolbar. Meaning - the defaul color there are now the same as the "Drawing" colors.
|
| COPYING SUM/IF FORMULA | 20 Aug 2008 04:01 GMT | 1 |
I am using excel 2007. Creating a inventory spreadsheet to show initial quantity and then a continous running total when used. I created a formula to hide 0 values. Example =if(sum(c7-e3)=0,"",(sum(c7-e3))).
|
| error "Excel has found unreadable Content" | 20 Aug 2008 03:54 GMT | 10 |
I created a large multi-sheet workbook with lots of Vba macro stuff. This worksheet has been working fine until lately. Just recently after some minor revisions I saved the file as I always have. The file will open fine, but as soon as make even a minor edit and save the file, ...
|
| How do i remove duplicate records in Excel 2007 | 20 Aug 2008 03:36 GMT | 1 |
I have a massive list of email addresses in Excel and I know there are many duplicates in it. How do I easily remove the duplicates so I have a clean list? P.S. I am not an experienced Excel user, so it might be obvious but I have no idea how to go about it.
|
| Formula to read formula in a cell | 20 Aug 2008 03:17 GMT | 5 |
In cell 'A1' I have the formula: =A2+A3 In B1, is there a way I can write a formula that will grab the first cell of that formula in 'A1' (in this example the answer would be A2).
|
| Date changes when copied and pasted | 20 Aug 2008 02:46 GMT | 4 |
I am having a problem where when copying rows that contains a date field into another workbook, the date actually changes (usually by minus 4 years and 1 day eg 04/10/2008 becomes 03/10/2004). The first workbook is an export from another program which we receive by email and is ...
|
| Excel and the Olympic Games | 20 Aug 2008 02:41 GMT | 11 |
I notice that various newspapers are beginning to proclaim "winners" for the Games based on medal count. The commonest counts can dealt with by Excel and it was interesting in 2004 that various reasonable weighting schemes for gold, silver, bronze, 1:1:1(total medals), 5:3:1 and ...
|
| how many blank cells it spans | 20 Aug 2008 02:02 GMT | 1 |
When a cell has a long content follows with empty cells, the content will dispaly over the empty cells. How to get the length of the content or the number of the empty cells it spans using VBScript or any other programming languages? Or how to check if an empty/blank cell is ...
|