| Thread | Last Post | Replies |
|
| How do I organize data from excel 2003 database into a word file? | 11 Nov 2007 23:03 GMT | 1 |
I am creating a neighborhood directory. I have my information sorted in alphabetical order and my column headings include...name, address, phone, etc. I would like to move the info into a word file and have the info go into pre-determined slots based on the column headings. ...
|
| convert into time format | 11 Nov 2007 20:11 GMT | 2 |
I want to make a simple timetabel for my employees. Instead of time format mm:ss I would like them just to type 1000 as in 10:00. I cannot find the right way, and do not have expert skills in Excel. pls. help. Henrik.
|
| Linest Poly Array using data horizontally | 11 Nov 2007 18:52 GMT | 1 |
All of our metrics store data horizontally, meaning Months (x) are stored by column and data series (y) are stored in rows below the months... Mo: 1 -- 2 -- 3--4 -- 5
|
| Conditional formatting | 11 Nov 2007 16:47 GMT | 4 |
can i select multiple columns at once so i can apply conditional formatting to all of them at once rather than individually. each column that i want to select is 6 columns apart? Any suggestions?
|
| Printing cell addresses | 11 Nov 2007 16:16 GMT | 3 |
I have a large worksheet which acts as a source for several other worksheets. Is there any way to print out the column and row headings AS ENTERED and the cell locations (w112) , not the cell contents or formula. This is only for
|
| countif function not working | 11 Nov 2007 16:12 GMT | 1 |
I have Excel 2002 and I have tried all I can but the countif function would not work.
 Signature Thanks
|
| Digitally signing VBA Project | 11 Nov 2007 13:25 GMT | 3 |
I want to digitally sign my macro, so that all our offices can use it (without prompts). I know I can use SelfCert.exe, but I would like one which is recognised by windows as a trusted source (so all my users don't have to add my self cert on every machine). I have spoken to ...
|
| XL 2K7 - can't sort values from formulas??? | 11 Nov 2007 12:01 GMT | 2 |
Entered numeric values in columns A-C and rows 1-5. In column E, entered numeric values 1-5. In column F, entered formula to add values in columns A-C: =A1+B1+C1
|
| formulas | 11 Nov 2007 10:06 GMT | 1 |
I need a formula to change dates less than 01/11/2007 into R with red background and dates more than 01/11/2007 to X with green background. Blank cells need to remain blank. I need to easily change the date every month. I can sort of get Excell 2007 to do it but at work have
|
| Calculating Dates | 11 Nov 2007 01:21 GMT | 3 |
I need to construct a spreadsheet that will tell me how many days have elapsed from x to the present. An example would be if I put in A1 10/10/07
|
| Need help making the first letter of Cell capitol | 11 Nov 2007 00:19 GMT | 1 |
I am making a list of names and need to make the first letter in each cell a capitol. How do I do this, also I'm a beginner with excel. My computer has Excel 2003 installed
|
| merge is greyed out | 10 Nov 2007 22:23 GMT | 4 |
I want to merge 4 similar workbooks I have copied all 4 files into the same folder and renamed them as: A B C & D In all 4, *Compare and merge workbooks is greyed out :-((
|
| reset value back to zero | 10 Nov 2007 16:57 GMT | 2 |
Please help me Spreadsheet set out as follows A B C 1 Total 0
|
| dynamic charting | 10 Nov 2007 15:31 GMT | 1 |
I am struggling a little with dynamic charting. I have a weekly figures to update with one x series and three y series. I am not after anything fancy. My x series is in column b with the y series in column g, h, i
|
| Removing items from worksheet by account number question | 10 Nov 2007 13:31 GMT | 3 |
I need to remove everything that is related to one account number and so on for other account numbers is there a way to do this or a way to highlight them... Thank you.
|