| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 49395 | 2004-09-18 00:36:00 | Excel Problem | heaton (3697) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 273371 | 2004-09-18 00:36:00 | If I have a column of money amounts in say a depreciation schedule and I want to reduce them all by say 2.5% printing out the answers in the next column and the reduced total in the third column, how do I do this for the whole column automatically ? | heaton (3697) | ||
| 273372 | 2004-09-18 00:48:00 | Assuming original amounts are in column A, formula for cell B1 is =A1*.025 formula for C1 is =A1-B1 copy cells B1 & C1 down the rest of the column |
wotz (335) | ||
| 273373 | 2004-09-18 02:12:00 | copy cells B1 & C1 down > the rest of the column Ok Thanks, but when I get to this part of the process all I get is the answer to =a1*.025 copied all down. Could you give me an exact step by step or mouse click by mouse click detail of the whole procedure please. Thanks again. |
heaton (3697) | ||
| 273374 | 2004-09-18 02:17:00 | Try typing the formula in two cells, just changing the cell reference, then select the cells and drag down - it should work. Hope this helps :) |
wintertide (1306) | ||
| 273375 | 2004-09-18 04:50:00 | , just changing > the cell reference, then select the cells and drag > down - it should work. Sorry but how do I change the cell reference without having to go down and change the cell reference for each line. I know there is a way to just somehow make it work automatically all the way down but I need someone to give me a mouse click by mouse click description of how it is done. |
heaton (3697) | ||
| 273376 | 2004-09-18 05:02:00 | Instead of typing the formula in the first cell of each column, type it in the first cell then again in the cell directly beneath but changing it (eg. if it's A1+B1, change it to A2+B2) then select those two cells and hover the mouse cursor over the bottom right corner of the selected cells. It'll change to a little black cross. Click and drag down the column. It should change the numbers for you automatically. Hope this helps. |
wintertide (1306) | ||
| 273377 | 2004-09-18 05:15:00 | When any formula is copied down or across using the drag method above as detailed by wintertide, the formulas are automatically adjusted without having to type again in the second cell. Also the formulas are automatically adjusted by a straight copy and paste. Try it and see. |
godfather (25) | ||
| 273378 | 2004-09-18 08:19:00 | By George I've got it, I've got it. Ever so thankful and my club depreciation schedule will be piece of cake. Thanks chaps, jolly good show what !!! | heaton (3697) | ||
| 273379 | 2004-09-18 10:31:00 | Hi Heath, another tip. If you have a column to the left of your formula, you can double-click the Fill Handle (the bottom right corner that has the +) and the formula will be copied down to the last row (or until the first blank) of the column to the left. eg A1:A10 are filled in with data. If your formula is in B1 and you double-click the fill handle, the formula will be copied down to B10. This is a bit quicker than dragging the formula down if you have a large # rows. hth |
parry (27) | ||
| 273380 | 2004-09-18 10:32:00 | err Heaton, not Heath. Sorry. | parry (27) | ||
| 1 2 | |||||