| Thread | Last Post | Replies |
|
| Office Clipboard | 08 Sep 2005 16:12 GMT | 1 |
How do i disable the office clipboard??
 Signature James_Newton ------------------------------------------------------------------------
|
| How Do I find distinct values in a Column | 08 Sep 2005 14:52 GMT | 5 |
I work in the Resourcing Dept. i have to prepare a list of candidates that were interviewed. I have to consolidate lists from four offices. I have come across duplicate candidates entries after consolidating the worksheets.
|
| Operator precedence (order of operate) =A1/A2*A3^5-(A1+A2) | 08 Sep 2005 14:33 GMT | 7 |
what is the order of operating and calculating in this formula? =A1/A2*A3^5-(A1+A2) 1- A1+A2 2- A1/A2
|
| Row Height Mystery | 08 Sep 2005 14:31 GMT | 1 |
It's a mystery to me anyway... Here's my situation: I have a file with multiple sheets... I selected 5 sheets in this file and changed the row height to 16.5 ... Later, I checked the height of the row by moving the cursor to one of the row indicators and clicking when the
|
| import | 08 Sep 2005 14:28 GMT | 1 |
I have a table in a html file and i want to import it to excel. After the import, the values like 04.02 or 11.04 or else... are transformed in 04.feb, 11.apr. I don't want that. What is the solution?
|
| Excel 2000 and Xml | 08 Sep 2005 14:25 GMT | 1 |
Does anyone know a way that you can save to XML in Excel 2000? Or any software which would allow this to happen?
|
| avoid repetitions in excel | 08 Sep 2005 14:21 GMT | 1 |
I am currently updating an excel worksheet created earlier on by someone else, How can I ensure EXCEL checks for any previous occurence of the rows similar to my new updates so I do not populate the worksheet with redundant repetitions ?
|
| Excel files reporting read only | 08 Sep 2005 13:53 GMT | 1 |
I have an issue where a user I provide support for is being told that a file that has not been opened for a couple of months is reporting as being locked for editing by the last user to save the file (in some cases these users no longer exist on our network). When you check the
|
| Password masking in a cell | 08 Sep 2005 13:49 GMT | 1 |
Is there anyway to mask a password as it is typed into the cell. Example is I type 5555 into cell A1 but to the viewing eye they only see ****. Is this possible. If so can I set up about 4 password that are validated after entry into cell A1. To allow or Dismiss.
|
| row header missing | 08 Sep 2005 13:47 GMT | 1 |
Hi all expert My excel row header (the numbering bar) is hided, how to unhide it?? Tried the Row & Column header option in the tools menu but not help. Please advice
|
| When is an Empty Cell not Blank? | 08 Sep 2005 13:46 GMT | 9 |
I am using the Advanced Filter to filter out records of companies that have not supplied a business number in that field (column). To my astonishment, it isn't filtering them out! Furthermore, on investigation, using "Edit, Go To..., Special, Blanks", these empty
|
| Extract each item in the list by function | 08 Sep 2005 11:03 GMT | 3 |
The cell A1 contains: Here's the shopping list: pig, dog, hamburger, chocolate..., beef. Please purchase all of them. Thanks! I would like to extract each item separately to different cells, ie
|
| Reference to content AND formating of target cell | 08 Sep 2005 10:58 GMT | 3 |
A1: =I am the <b>best!</b> (<b>...</b> means bold letters) A2: =A1
|
| Crop text | 08 Sep 2005 10:50 GMT | 1 |
How can I do the following: - crop text from the left eg: CropText(A1, Crop3WordFromLeft) - crop text from the middle
|
| Return "cell reference" | 08 Sep 2005 09:50 GMT | 14 |
How to do the following: 1) Return the cell reference of the cell eg: Type this formula in cell A1:
|