introduction excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Introduction Excel

resolvedResolved · Medium Priority · Version 2003

replyReply Thu 20 Nov 2008, 09:45Delegate Stefania said...

Introduction Excel

I would like to khow how to link two worksheets

For upcoming training course dates see: Pricing & availability

replyReply Thu 27 Nov 2008, 11:56Trainer Amanda said...

RE: Introduction Excel

Hello Stefania

Thank you for your question.

You can create a link between two worksheets by creating a simple formula.

1. Select the cell you wish to create the link in.
2. Type in =
3. Click on the sheet containing the cell you want to link to.
4. Press Enter.

Kind regards
Amanda

 

Please browse our web site to find out more about
excel-training-course and other Microsoft training courses.

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard