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

Hyperlinks

ResolvedVersion 2010

Thu 4 Jun 2015, 16:04 Delegate Hai-anh said...

Hai-anh has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Dashboards for Business Intelligence course
Influencing Skills course
Negotiating Skills course

Hyperlinks

Hi,

Is there an easy way to set hyperlinks in whole columns, rather than do it manually?

Many thanks,

Hai-anh

Thu 4 Jun 2015, 16:33 Trainer Jens said...

RE: Hyperlinks

Hi Hai-anh,

Thanks for the forum question.

Each cell in the range need to know where to link to.

If it is web addresses or email addresses Excel will pick up it is a hyperlink.

What are you trying to do?

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Hyperlinks

Hyperlinks

RE: Hyperlinks

Excel articles

Excel tip:

Sorting List Subtotals