Copy Cell Sum

  • Thread starter Thread starter Nad
  • Start date Start date
N

Nad

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.
 
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!
==============================================

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
 
After you copy, press F9 to recalculate. Or set calculation to automatic.
(tools>options>calculation tab>automatic)

Carlos
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Sum in Excel 1
SUM Char 9
Copying summed cells 2
How can I copy the sum of a filtered column into a cell in anothe 1
Why won't my spreadsheet SUM??? Help 3
use month in cell date to sum all relevant cells 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
sum of multiple rows 2

Back
Top