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

formulas

ResolvedVersion Standard

Hash has attended:
Excel Introduction course

Formulas

how do you link different sheets

Edited on Tue 18 Mar 2008, 10:11

RE: formulas

Hi Hash, Thanks for the post, Welcome to the forum, in answer to your question, this is quite a simple thing to do, in the sheet (Sheet1) active cell that you wish to have the link, place an equals sign (=) and then change to the sheet (Sheet2) you wish to link to using the tabs at the foot of the workbook and select the cell to be linked.
Press Enter and you will see the data in Sheet1 will be exactly that as in Sheet2.
You can create formulas that link worksheets and even workbooks in the same way. I hope that helps, best regards Pete.

 

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:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

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