Formulas

Resolved · Low Priority · Version 2003

Wed 10 Mar 2010, 16:32 Delegate Alison said...

Alison has attended:
Excel Introduction course
Word Intermediate course

Formulas

How do you link different sheets with formula?

Thu 11 Mar 2010, 10:37 Trainer Simon said...

RE: Formulas

Hi Alison,

Thank you for your question.

Imagine you have a cell in Sheet 1 of your workbook which contained the value of 60. This figure then needs to be linked into Sheet 2 which is used in another formula.

Copy the cell containing 60, switch to Sheet 2 and click into a cell and then use the Edit - Paste Special - Paste Link command. So any changes to the cell in Sheet 1 will update the cell in Sheet 2.

Then in another cell on Sheet 2 you could create a formula which includes the linked cell.

I hope this answers your question.

Regards

Simon

Wed 17 Mar 2010: Automatically marked as resolved.

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Closing Multiple Workbooks quickly