« How do I make multiple groups of worksheets in an Excel workbook?
Why should students have to memorize multiplication facts? »

In Excel 2003, how do you copy a cell from one worksheet to another?

I am creating a productivity sheet that calculates an average number of units per time. I want to copy that result to another worksheet. Help?

To copy a cell between worksheets of workbooks:

If the content of the cell does not have a formula, then copy and paste as usual.

If the content of the cell you want to copy has a formula then to copy the cell between worksheets/workbooks you need to create a link between the cells (use a formula to indicate: this cell is equal to that cell):
• Select the cell that you want to contain the link, type the equal sign (=)
• Select the source worksheet, then select the source cell
• Press enter

If you want to have on the destination cell the value and not a link between the cells, then after you finish doing the steps above:
• Select the destination cell and right click and select copy
• Select the destination cell and right click and select PASTE SPECIAL
• From the options select VALUES and click OK
In this way you copy the cell value and eliminate the link between the cells

Hope this help

This entry was posted on Sunday, December 27th, 2009 at 8:55 pm and is filed under worksheet. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “In Excel 2003, how do you copy a cell from one worksheet to another?”

  1. LoverOfWine Says:
    December 28th, 2009 at 2:40 am

    Copy (ctrl-c) and paste (ctrl-v) or cell referencing (in sheet2 A1 put =sheet1!A1 to copy the value in A1)
    References :

  2. gospieler Says:
    December 28th, 2009 at 3:02 am

    To copy a cell between worksheets of workbooks:

    If the content of the cell does not have a formula, then copy and paste as usual.

    If the content of the cell you want to copy has a formula then to copy the cell between worksheets/workbooks you need to create a link between the cells (use a formula to indicate: this cell is equal to that cell):
    • Select the cell that you want to contain the link, type the equal sign (=)
    • Select the source worksheet, then select the source cell
    • Press enter

    If you want to have on the destination cell the value and not a link between the cells, then after you finish doing the steps above:
    • Select the destination cell and right click and select copy
    • Select the destination cell and right click and select PASTE SPECIAL
    • From the options select VALUES and click OK
    In this way you copy the cell value and eliminate the link between the cells

    Hope this help
    References :

Leave a Reply