Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formulas

ResolvedVersion 2007

Rachel has attended:
Excel Introduction course
Excel Intermediate course

Formulas

How do i link formulas in one sheet to other formulas in another sheet?

RE: Formulas

Hi Rachel

Thank you for your question.

There are two ways of linking cells between sheets.

1. Select a cell in the sheet you wish to create the link in; then type in = and select the cell in the other sheet you want to link to. Press Enter.

2. Select the cell you wish to create a link to and copy it. Go to the cell you wish to create the link in, then go to Edit - Paste Special and click the Paste Link button.

I hope this helps.
Amanda

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.