| Thread | Last Post | Replies |
|
| print hidden values | 05 Sep 2006 23:37 GMT | 1 |
I have a spreadsheet that has two cells that I have hidden by going into format cells to number and typed ;;; (3 semicolons) in the type box. I would like to be able to have the sheet print without the value showing on the screen. Does anyone know how to set a macro to allow ...
|
| Open an excel Book. How can I speed it up? | 05 Sep 2006 23:36 GMT | 5 |
It takes me 3-4 min. to open an Excel Book. I have cable (Road Runner) and am using USB from modem to tower.Have XP On my old slow puter using ME it always brought the book up in secs. HELP! Am also a beginner - know how to turn on and off and thats about it.
|
| Sort Cells/Columns | 05 Sep 2006 23:19 GMT | 6 |
I have three lists of items (numbering about 150) on a single sheet using columns A, D & G. I need to sort these in alphabetical order continuous across all three columns. All I get at the moment is each column individually sorted, which
|
| Cell Selection Bug!! | 05 Sep 2006 23:16 GMT | 1 |
Not sure if anyone has seen this before: if a selection in BookA is copied to BookB whatever was originally selected in B stays selected aswell as what is copied in e.g say you select A16 in BookB then go into BookA and copy A1:C1, go back to BookB
|
| Summing cells with no value ("") and obtaining "" | 05 Sep 2006 21:45 GMT | 5 |
I have a column of cells that if there is no value in any of the cells (""), It needs to return "". When I sum the cells, It still returns a "0" even when there is nothing in cells. Any suggestions? Thanks.
|
| Complex Number Formatting | 05 Sep 2006 21:33 GMT | 16 |
While trying to set up a vector "Cross product matrix". -- technically not really a matrix, but rather just mechanically calculating the determinants from the entries within a square matrix. I ran into a major
|
| Hide two cells until print | 05 Sep 2006 20:48 GMT | 1 |
I would like to be able to hide the contains of two cells when on the screen but have it show when it is printing. Anybody have any ideas?
|
| How do I change to name of my column | 05 Sep 2006 20:48 GMT | 1 |
Hi I am looking to change the name of my column on the worksheet from A, B, C, To specific names can I do this
|
| If-Then-Else Statement | 05 Sep 2006 20:16 GMT | 2 |
It is not executing my If-Then-Else statement. It seems the only statement being executed is: Cells(Row, Col).Value = Range("K" & Row) and I only want it to do that if the condition is true, and put a 0 in each cell in the range if it is false. Can someone
|
| subpie from pie | 05 Sep 2006 19:59 GMT | 1 |
Hi, dear group! Everytime whenever I try to create a subpiechart from a pie-piece I get it wrong! Is there a special way of selecting the cells before you make the nested pie
|
| calculate percentile for indexed numbers. Thanks | 05 Sep 2006 19:19 GMT | 1 |
Hi, I have a large series of numbers saved in one column [34,5,21,98,34,3,432,55,27,90,1125,......]. These data are indexed, e.g. by [1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,......N] which are in another column. Basically I am calculating the 25% percentiles for numbers indexed "1", "2",
|
| ¿como quito la proteccion de un libro? | 05 Sep 2006 19:13 GMT | 1 |
por favor que alguien me ayude necesito desactivar la proteccion de un libro por que necesito modificar unos datos pero todas las opciones estan desabilitadas
|
| Gridlines problem Excel 2000 | 05 Sep 2006 18:22 GMT | 4 |
I am trying to print gridlines on a workbook and instead of getting the gridlines, I am getting a line around the outside of the data, like a text box frame. I have been using gridlines for quite a long time and never came across this before. I tried turning the lines off and ...
|
| Code returns TRUE instead of value | 05 Sep 2006 17:20 GMT | 2 |
Essentially what I am trying to do is this: I am trying to calculate depreciation. I use the DateAdd function to add x number of months(Cell "F & Row that is active") to the acquisition date(Cell "H & Row that is active" of
|
| Excel is not working! | 05 Sep 2006 16:49 GMT | 3 |
I open excel. As soon as I moe the mouse to any cell the mouse sticks ther and gabs cells. I must close excel. What is up?
 Signature t
|