formulas

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · Low Priority · Version 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:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips


Server loaded in 0.09 secs.