Jun 12 2007

Hyperlink Formula in Excel

I’m going to add this section to the Microsoft Excel Help section (menu on the left) of the website. An excel user contacted me and questioned how to create a hyperlink inside of excel using the value in another cell to as part of the link. The Formula looks like this:
HYPERLINK(link_location,friendly_name)
where link_location is where you [...]

XLAutomation
Get Expert Excel Help Today! 714.262.6893
Easily design MySQL databases as familiar spreadsheets in Micros
Easily design MySQL databases as familiar spreadsheets in Micros

Categories

Excel Poll of the Week

How often do you use Excel macros (VBA)?

View Results

Loading ... Loading ...

Category Cloud

Add Comments Column Headers Concatenate Contest Count CountA CountBlank CountIf Date Drop Down Menu Excel Forum Excel Info Excel Macros Excel Version Formatting HLookup Hyperlink ISBLANK ISERROR ISNA Keyboard Shortcuts Large Left Length Loan Payment Calc Loops Match Mid Protection Rank Record a Macro Right Select Whole Sheet Site Updates Small Status Bar Messages Substitute SumIf Today Trim VLookup

Most Viewed