training microsoft excel - hyperlink
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 » training microsoft excel - Hyperlink

Recommend training98.1 %
recommend us
More live stats...

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

Training information:

See also:

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

See also:
Hints and tips
Forum topics

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.

training microsoft excel - Hyperlink

resolvedResolved · Low Priority · Version Standard

replyReply Wed 12 Sep 2007, 15:28Delegate Apurva said...

Apurva has attended:
Excel Advanced course

Hyperlink

How to link non Excel Files?

For upcoming training course dates see: Pricing & availability

replyReply Tue 25 Sep 2007, 11:54Trainer Anthony said...

RE: Hyperlink

Hi Apurva. Add the title of your non-Excel file to a cell, right click on that cell and select hyperlink. Then navigate to the location of your file. Simple as that!

Hope this helps,

Anthony

 

Excel articles

· Improve Performance Of Your Excel Macros
· Sorting Out Your Data In Excel
· How To Pick The Best Chart Type In Excel
· How To Identify The Most Critical Data In A Large Excel Spreadsheet
· Learn How To Chart Your Deeper Data

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

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

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy