| Thread | Last Post | Replies |
|
| Pivot table headache | 22 Sep 2006 15:59 GMT | 2 |
I have a tricky little problem that I need to solve and I really need some help. I'm trying to study attrition rates and get the data onto a graph, the way I want it.
|
| In Excel why does the / key activate the menu bar? | 22 Sep 2006 15:51 GMT | 4 |
A user wants to enter text in a cell beginning with the forward slash character. When she does this it simply activates the File menu but does not enter the / in the cell.
|
| ribbon changed after reboot | 22 Sep 2006 15:36 GMT | 2 |
hey, anyone have this happen to them? ...installed TR for Beta2 and was checking out the changes in Excel. I noticed that the ribbon icons have changed somewhat from beta2 - things are condensed a bit... however, after a reboot, my ribbons reverted back to what they were BEFORE I ...
|
| How do you get around &T converting to time in header. | 22 Sep 2006 14:01 GMT | 1 |
I need to use &T as part of text in an excel sheet header. It converts to time. Is there a way of getting around this conversion?
|
| Hyperlinks in Excel | 22 Sep 2006 13:33 GMT | 3 |
Is there anyway to create a hyperlink in Excel(2003 sp2) to another document that opens in a new window? Any help on this would really be appreciated.
|
| No. of rows selected from auto filter not visible on toolbar? | 22 Sep 2006 13:05 GMT | 2 |
When i put an auto filter on a column on excel, and select a particular option from the drop down filter menu, the number of rows selected for that option is not appearing at the bottom left hand corner on the toolbar....
|
| WHAT FUNCTION SHOULD I USE? | 22 Sep 2006 12:25 GMT | 1 |
Im a very rookie.. i want to make a quiz using excel 2003.. ex.. i insert batman forever poster.jpg on it then i put a question below..
|
| date format | 22 Sep 2006 12:03 GMT | 2 |
I need to enter data into excel and have it remain in "general" format rather than have it become a date (eg when i enter 3/1952 it becomes 3 march 1952) this happens with any viable number that can conceivably be interpreted as a date (5/2500 also becomes a date!). How can i ...
|
| How do I remove text limit on a cell | 22 Sep 2006 11:06 GMT | 1 |
I’ve created a program in Visual Basic which transfers data to a new work book but it gets chopped short after a predetermined number and I can’t find how to change it.
|
| Data entry too slow even with calc set to manual | 22 Sep 2006 11:00 GMT | 1 |
I am using Excel 2002 and the workbook concerned is 20MB in size. I have set the calculation mode to manual to try to speed up data entry but it doesn't seem to make much difference. Changing the data in a data cell still takes too long. When I press enter after amending data
|
| rank | 22 Sep 2006 10:54 GMT | 2 |
I have a list of data that I need to rank from 1-?? based on two sets of criteria. here is an example of what I need. Customer Name Product Sales Rank Customer A Product 1 100 1
|
| Is this code error-bearable | 22 Sep 2006 10:39 GMT | 2 |
following is a code to delete all contents of Two drives.But it is not working if first drive is not found. Is there a possibility to bypass the code if the drive is not there in system or any code to find if there is <drive letter> drive in the system.
|
| Populate lists automatically | 22 Sep 2006 10:08 GMT | 5 |
I have a requirement which has 2 lists to be populated automatically. The 2nd list value is based on the 1st list. For eg: 1st List 2nd List Fruits (Should display list of all fruits mentioned)
|
| Is it possible to copy a conditional format formula as paste value | 22 Sep 2006 09:39 GMT | 2 |
I have several rows of data with a header row that has a conditional format applied depending on a row below. When I copy that header row to another sheet, the conditional formula still refers to a row which is no longer where it expects it to be. (because I
|
| change date default settings | 22 Sep 2006 07:52 GMT | 1 |
hi i need to create a list in excel using the date format 21- Sep. everytime i do this it automatically formats this as 09/21/2006 how do i change this?
|