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

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.1 secs.