| Thread | Last Post | Replies |
|
| is it a virus? | 16 Sep 2005 02:36 GMT | 6 |
I've closed all the workbook in excel, but it still show a workbook with sheets in Microsoft Visual Basic Editor. What happen? Many thanks for any help. Ndoel
|
| how can I omit the array( numbers and letters for columns and row | 16 Sep 2005 02:34 GMT | 1 |
i want to print without the numbers of the rows and without the letters in each column. how can i do this?
|
| USING EDIT FIND to locate cell references | 16 Sep 2005 01:59 GMT | 3 |
If I put various cell references inside a formula, is there an easy wa to find the reference without going into each and every cell. Fo example if cell C6 is "=IF(ISERROR(T9/Q9),"",T9/Q9)" and I want to fin all references to T9 can I somehow convert cell C6 to be say the text o
|
| Can't right-click in excel | 16 Sep 2005 01:57 GMT | 1 |
I have a user that showed me the most interesting issue. She is unable to right-click while using Excel. In any other program or even on the desktop she can righ-click and bring up the appropriate right-click menu. But in excel this does not
|
| emails | 16 Sep 2005 00:38 GMT | 1 |
i have received an email but it wont let me open it , it says i need to go on to this site (excel) to see what i need to download to get this email. im so confused because it doesnt really help me out in anyway. how can i read this email, and what do i have to download?
|
| Converting time | 16 Sep 2005 00:30 GMT | 2 |
How can I convert 1m38.15s or 0m58.98s into seconds in decimals ie:98.15 or 58.98. I've tried formatting the column next to the data "ss.00" but it does not work. Any help would be appreciated.
|
| How to append text to calculated values | 16 Sep 2005 00:14 GMT | 2 |
I have a cell that calculates power in Watts. I'd like to append a W in the same cell, anyone know how to do this?
|
| formulas to numbers | 16 Sep 2005 00:08 GMT | 2 |
I want to create a table (by "table" I just mean a bunch of columns of numbers and formulas laid side by side, I don't know whether "table" has a more technical meaning) where I manually enter a column of numbers, and update those numbers periodically. The table is of fixed size ...
|
| Cell value & hyperlink | 15 Sep 2005 23:16 GMT | 2 |
I have a workbook with 250 sheets... named like so Sheet01...Sheet250 I want a cell to contain the number value of each sheet (01, 02, etc) while also being a hyperlink so when the cell is clicked the workbook automatically displays that sheet.
|
| Excel memory issues | 15 Sep 2005 22:39 GMT | 4 |
We have several excel spreadsheets on a network drive that when opened by any client they receive several errors relating to memory, such as: Not enough memory Not enough system resources to display completely
|
| creating a smaller list from a big one | 15 Sep 2005 22:33 GMT | 2 |
I have a long list of items with about about 8 cells of information i every row. I want to create a column down the side if the list with a tick/chec box or something similar which if ticked will send the row into a ne
|
| how do i use colours with formulas in excel? | 15 Sep 2005 22:26 GMT | 2 |
I am trying to create a spreadsheet of results using formulas and I want to have cells highlighted depending on the outcome in different colours ie pass (green) fail (red) etc
|
| Conditional formatting Question | 15 Sep 2005 22:17 GMT | 7 |
I am running office 2003 more specifically excel 2003. I have a project list that I have set up conditional formatting on to set every other row to a shaded line. My understanding is that "conditional formatting" should hold that procedure if you sort or filter. For some ...
|
| Help with drop-down list (2003) | 15 Sep 2005 22:16 GMT | 3 |
Is there any way to control how the dropdown list is displayed? Specifically, I have a data validation list in a cell. The column it is in is only 4 units wide, with the text aligned at 90 degrees (vertically). The dropdown list displayed is also only 4 units wide,
|
| Chart Problem | 15 Sep 2005 21:27 GMT | 1 |
How can I produce a horizontal column chart of the values in A1:A40 to read left to right - i.o.w. the value A40 on chart left and the value A1 on right of chart. Many Thanks
|