Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Linking

	98.1 % recommend us
	More live stats...

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

Training information:

excel training - Linking

Resolved · Low Priority · Version Standard

Reply Thu 6 Dec 2007, 17:40Delegate James said...

James has attended:
Excel Advanced course

Linking

Are you able to link cells across a workbook ?

For upcoming training course dates see: Pricing & availability

Reply Fri 7 Dec 2007, 09:40Trainer Katie said...

RE: Linking

Hi James,

Thank you for your question.

You can set up a hyperlink to another cell / worksheet / workbook.

1) Select a cell to establish the link
2) INSERT menu > Hyperlink or CTRL+K
3) Select Link to :
[Exisiting File or Web Page] for a different workbook or
[Place in This Document.] for a cell / worksheet in current workbook.
4) Once you have locate the selection, press OK

N.B. You may also add SCREEN TIP to add on instructions to the cell.

Hope this helps.

Regards,

Katie

Excel articles

· The Secret Formula To Creating Correct Calculations In Excel
· How to Create Better Excel Spreadsheets: Part One
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Why Should I Learn Visual Basic in Excel?
· Interesting Things About Charts In Excel 2003

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips