Share this article...

How to carry over a value onto another spreadsheet (without typing it again)

 Microsoft Excel Tips


Why is it called a Workbook?

Before we begin it would be wise to establish some basics about an Excel file. When you open up a new file notice the little tabs at the foot of the screen labelled Sheet1, Sheet2 and Sheet3. When you open up a new file you are creating a Workbook - a collection of one or more spreadsheets. You can type values, text and formulae in each Sheet and switch between them by clicking the tabs.

Linking Sheets

Say you had a formula that adds up the results of a column on Sheet1 and you wanted to carry over that result into a cell at the top of Sheet2.

This is how you do it.

1. Click once in the cell on Sheet2 (where you want the resulting amount to be displayed from Sheet1)

2. Type =(an equals symbol just left of the backspace key)

3. Now click on the Sheet1 tab and click once on the cell that has the total

4. Now Press the Enter Key on your keyboard

Now wasn't that easy?

What about displaying a whole row?

Say you had a row of values going across 10 adjacent cells on Sheet1. It would be a bit of a chore to use the technique above ten times to display them all on Sheet2.

This is what you can do instead:

1. Select (by clicking and dragging across) the ten cells in Sheet1

2. Copy (Ctrl+C) (you will see 'marching ants' around your selection)

3. Click on the Sheet2 tab and click in the first left hand empty cell

4. Right Click on the same cell and select Paste Special (a screen will pop up)

5. Click the PASTE LINK button at the bottom

Hey Presto!

Now try changing values on Sheet1 and check Sheet2 - it will change. - as if by magic

Share this article...
Was this article helpful? Add your comment below...

Design Your Excel Training


Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 179

    Sushila has awarded Barry a Virtual Cake for "helping me set up some complicated systems during...

  • Thanks No. 178

    Emma has awarded Dominic a Virtual...

  • Thanks No. 177

    Catriona McMullen has awarded Dominic a Virtual Beer because "Thanks for sorting problem with...

  • Thanks No. 176

    Sam has awarded Dominic a Virtual Beer because "Brilliant service as...

This website uses cookies to help us improve your experience.
By using our website you accept our Privacy Policy and use of cookies.