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

excel training - linking

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

excel training - Linking

ResolvedVersion Standard

James has attended:
Excel Advanced course

Linking

Are you able to link cells across a workbook ?

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 tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

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.