Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Office general help » Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel

Resolved · Low Priority · Version 2000

Reply Wed 17 Sep 2008, 13:57Delegate Katherine said...

Katherine has attended:
Excel Introduction course
Upgrade to Office 2007 course
Powerpoint Intermediate Advanced course

Excel

How do you link different worksheets within excel, so that numbers correspond?

For upcoming training course dates see: Pricing & availability

Reply Wed 17 Sep 2008, 14:17Trainer Amanda said...

RE: Excel

Hello Katherine

Thank you for your question.

You can link one cell with another by doing the following:
1. Select the cell that you wish to link to another cell.
2. Type in =
3. Navigate to and select the cell that contains the figure/value that you want to link to, and select that cell.
4. Press Enter.

This creates a one way link from the cell that contains the figure/number and the cell you have created the formula in to link to that cell. This way if the figure/value changes, it will also change/update in the cell where you have created the formula.

Amanda

Microsoft Office articles

· Are You Ready To Let The Cloud Lift Your Business?
· Living The High Life, Thanks To MS Office?
· Getting the most out of your Microsoft Office Training
· Office for the sole trader - and not just for offices!
· Use Training To Get Financial Control

Please browse our web site to find out more about
microsoft office training and other Microsoft training courses.

Microsoft office tip:

Renaming or Deleting Files when Saving or Opening

You can rename and delete files any time you are using a FILE > OPEN or a FILE > SAVE dialog box.
When you see the list of files when browsing in the current folder, you can treat is just like the windows explorer window, by selecting and then editing.

To rename, just give the file a single click to select, then a second to enter the file name. Type the name you want, and press enter.

To delete, a single click and hit the delete key.

View all Microsoft Office hints and tips