advanced excel seminar training - hyperlinks
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 » advanced excel seminar training - Hyperlinks

advanced excel seminar training - Hyperlinks

resolvedResolved · Low Priority · Version Standard

replyReply Mon 17 Sep 2007, 14:33Delegate Jane said...

Jane has attended:
Excel Introduction course
Powerpoint Introduction course

Hyperlinks

how do I put in hyperlinks to access information from my files

For upcoming training course dates see: Pricing & availability

replyReply Tue 25 Sep 2007, 10:53Trainer Anthony said...

RE: hyperlinks

Hi Jane. Put the title of your file in a cell and then right click on that cell and choose hyperlink. Then navigate to the location of your file. Simple as that!

Hope this helps,

Anthony

 

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

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