|
Copy Cell Sum
How do i copy a cells format. I have got a cell which adds up a whole
column, what I would like is other columns to do the same but there must be an easier way of doing it without clicking the bottom of each column and then clicking the sum tool? can i copy this function? Thanks |
After you get the first one have you tried dragging the formula. grab the
bottom right of the cell. -- Don Guillett SalesAid Software "Nad" wrote in message ... How do i copy a cells format. I have got a cell which adds up a whole column, what I would like is other columns to do the same but there must be an easier way of doing it without clicking the bottom of each column and then clicking the sum tool? can i copy this function? Thanks |
With relative references being used (no $ in cell addresses), simply click
on the "fill handle" of the cell containing the original formula, and drag across the columns to automatically copy the formula as far as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Nad" wrote in message ... How do i copy a cells format. I have got a cell which adds up a whole column, what I would like is other columns to do the same but there must be an easier way of doing it without clicking the bottom of each column and then clicking the sum tool? can i copy this function? Thanks |
tried that but it also copies the numbers in that cell?
Thanks Don Guillett wrote in message ... After you get the first one have you tried dragging the formula. grab the bottom right of the cell. -- Don Guillett SalesAid Software "Nad" wrote in message ... How do i copy a cells format. I have got a cell which adds up a whole column, what I would like is other columns to do the same but there must be an easier way of doing it without clicking the bottom of each column and then clicking the sum tool? can i copy this function? Thanks |
dose not work
RagDyer wrote in message ... With relative references being used (no $ in cell addresses), simply click on the "fill handle" of the cell containing the original formula, and drag across the columns to automatically copy the formula as far as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Nad" wrote in message ... How do i copy a cells format. I have got a cell which adds up a whole column, what I would like is other columns to do the same but there must be an easier way of doing it without clicking the bottom of each column and then clicking the sum tool? can i copy this function? Thanks |
Would you post the *exact* formula you're trying to copy?
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "Nad" wrote in message ... dose not work RagDyer wrote in message ... With relative references being used (no $ in cell addresses), simply click on the "fill handle" of the cell containing the original formula, and drag across the columns to automatically copy the formula as far as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Nad" wrote in message ... How do i copy a cells format. I have got a cell which adds up a whole column, what I would like is other columns to do the same but there must be an easier way of doing it without clicking the bottom of each column and then clicking the sum tool? can i copy this function? Thanks |
After you copy, press F9 to recalculate. Or set calculation to automatic.
(toolsoptionscalculation tabautomatic) Carlos "Nad" wrote in message ... tried that but it also copies the numbers in that cell? Thanks Don Guillett wrote in message ... After you get the first one have you tried dragging the formula. grab the bottom right of the cell. -- Don Guillett SalesAid Software "Nad" wrote in message ... How do i copy a cells format. I have got a cell which adds up a whole column, what I would like is other columns to do the same but there must be an easier way of doing it without clicking the bottom of each column and then clicking the sum tool? can i copy this function? Thanks |
all done, thank you all
RagDyer wrote in message ... Would you post the *exact* formula you're trying to copy? -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "Nad" wrote in message ... dose not work RagDyer wrote in message ... With relative references being used (no $ in cell addresses), simply click on the "fill handle" of the cell containing the original formula, and drag across the columns to automatically copy the formula as far as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Nad" wrote in message ... How do i copy a cells format. I have got a cell which adds up a whole column, what I would like is other columns to do the same but there must be an easier way of doing it without clicking the bottom of each column and then clicking the sum tool? can i copy this function? Thanks |
| All times are GMT +1. The time now is 05:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com