| Thread | Last Post | Replies |
|
| Demerge Concatenate | 03 Nov 2007 13:45 GMT | 2 |
i want to demerge the content cell a lot of data into 2 or 3 steps
|
| Excel 2007 Graphs | 03 Nov 2007 10:36 GMT | 2 |
There seems to be issues with Excel 2007 and graphing, i.e. it is slow to the point of being useless. I notice that there is a hotfix for this problem (KB938538), but there doesn't seem to be anywhere to download this without incurring a £199 cost?
|
| How can I update the latest cost paid for a part? | 03 Nov 2007 01:04 GMT | 2 |
I'm not very experienced with Excel but I'm trying to use 2003 to keep a parts inventory. I'm keeping the inventory of parts on one sheet and the purchase record of parts that I've purchased on another sheet. The purchase record consists mainly of a column with the purchase ...
|
| format a list of names to mailing labels | 03 Nov 2007 00:46 GMT | 2 |
As was asked in a earlier question --I have a mailing list of names in rows Name Address City State Zip that I need to format into mailing labels. I am now using Vista and can't figure out how to do this. Do I copy the names I received in an Excel do to a Word doc and try to use ...
|
| Yet more validation ... challenges! | 02 Nov 2007 23:18 GMT | 27 |
Bob/Rick - are you there?! Having done some more testing with the validations that you have each helped me with, I have found a couple of problems. The code that I have for validating times works fine except that, having
|
| Excel 07 selects 3 cells when I click on 1 | 02 Nov 2007 18:43 GMT | 1 |
Hi I just got 2007 (I want 2000 back) and a lot of the time when click on an empty cell 2 or more below it are selected and the typing goes on the bottom row. I just want to select the cell I click on. Thanks
|
| Weekly Mortgage template | 02 Nov 2007 16:59 GMT | 10 |
Anyone know where I can get a mortgage template, such as the one at http://office.microsoft.com/en-au/templates/TC062062831033.aspx, except with an option to display and report on weekly payments and balances, rather than monthly only?
|
| list function | 02 Nov 2007 16:13 GMT | 1 |
I have 10 student names put in from cell a1 to a10 in sheet1, and their age put in from b1 to b10. I created a list of student names by selecting cell a1 to a10. I go to sheet2, cell a1: I created a drop drop list of student name. I want cell b1 in sheet2 to auto pop up the ...
|
| Negative numbers parentheses | 02 Nov 2007 15:53 GMT | 12 |
I want to see negative numbers in parentheses in Excel 2000 SP3 and can't get it to work. Though regional settings show negative numbers like this (-1) it's not the case in excel. If I use a custom format it works but just for the current session. The newly defined format won't ...
|
| i`d like to change the direction of office 2007 to left to right | 02 Nov 2007 14:14 GMT | 8 |
the direction of the excel sheet is from right to lef i want to change to left to right not only excel all office i wnt to change thank you
|
| Sorting by colour | 02 Nov 2007 12:40 GMT | 2 |
Is it possible to sort a list by font colour? I am trying to find an easy way to synchronise the data between two spreadsheets and am thinking that colour-coding the text in one of the spreadsheets would make this process easier.
|
| Programmatically change an existing Pivot Table | 02 Nov 2007 12:38 GMT | 3 |
Hello to everyone, wondering if someone has figure out how to change existing Pivot Tables. Once a pivot table is been created the SourceData is read only. Creating a new pivot table using VBA is too complex and time-expensive. Any suggestions?
|
| How do I filter data without including the header row? | 02 Nov 2007 12:37 GMT | 1 |
When filtering my data in spread sheet it continues to include my header rows as apart of the filtering process, I've tried freezing the frame to include columns.
|
| How can you count three seperate 'things' in one column? | 02 Nov 2007 12:35 GMT | 2 |
I have a spreadsheet column where each cell will either have a tick, a cross or is left blank. How can I setup three cells to show how many ticks,
|
| How do I count three different things in one column? | 02 Nov 2007 12:34 GMT | 1 |
I have a spreadsheet where a column will have either a tick, a cross or is left blank. How can I setup three cells to show how many ticks, crosses and blanks there are in the column? I hope this is clear as what I am trying to do.
|