The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Hyperlinks

Resolved · High Priority · Version 2003

ReplyMon 29 Jun 2009, 14:25Delegate Gareth said...

Hyperlinks

Hey

Im trying to link from excel to a specific word document that looks up the text value of one cell and searches and finds the exact document in another folder.

For example in column AF I have a number like '56TD67890'.

On the company server I also have a word document that goes by the same name. Im trying to create a hyperlink to the server that takes me directly to the word document that matches the text value in column AF.

Is this possible?

Thanks

For upcoming training course dates see: Pricing & availability

ReplyMon 29 Jun 2009, 14:27Trainer Amanda said...

RE: Hyperlinks

Hi Gareth

Not sure about this one myself, I'll ask one of my colleagues to have a look at this for you tomorrow.

Kind regards
Amanda

ReplyWed 1 Jul 2009, 12:03Delegate Gareth said...

RE: Hyperlinks

I have tried combining the concatenate function with the hyperlink but it doesn't work. Any advance on if this is possible?

Thanks in advance.

ReplyMon 20 Jul 2009, 09:37Trainer Stephen said...

RE: Hyperlinks

Hi Gareth

I apologise for the delay in replying. I have been away from work for the last few weeks due to illness.

I realise that you may have already solved the problem, if this is not the case could you please advise me so that I can giver it my urgent attention

Regards

Stephen

Mon 27 Jul 2009: Automatically marked as resolved.

Excel articles

· Microsoft Office and the Small Business: Part 1 Excel
· Using Excel For Simple Home Accounting And Budgets
· Charting Your Success With Excel 2007
· How To Convert Text To Columns In Excel
· Discover How To Use Fill In Excel

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

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

Using The Drawing Toolbar In Excel

Excel is basically an electronic version of hand-written ledgers that went before it, and in these great books there was no room, nor any need, for any kind of graphics to accompany the data.

Not so in Excel where are all manner of graphics can be incorporated into worksheets. Here we look at the basics of the Drawing toolbar.

» Article: Excel training

How do i save a 2 worksheets in one?

» Forum post: Save

If you are working with text and numbers and want to convert the chemical symbol for water H20 so that the 2 is lowered, you can highlight the number 2, click on Format-text and check on the Subscript box