Hi,
Some of us should be aware of hyperlink feature in excel. But Microsoft has provided a seperate function called HYPERLINK like SUM, AVERAGE function. Why did they do so? There might be some thought process behind it, right?
That's what we are digging into this week.
Scenario which we have taken here is, we have three different department files where
people have to update their department file by simply selecting their department in a drop down and clicking on a link.
Check out the attachments which illustrates how we solved this requirement using hyperlink function.
Hope this illustration would give you some idea, where you can make use of HYPERLINK function in your work.
Wish you a great week ahead...
With best regards,
Hariharan Ramakrishnan
Microsoft Office Applications Trainer / Consultant
From India, Chennai
23Some of us should be aware of hyperlink feature in excel. But Microsoft has provided a seperate function called HYPERLINK like SUM, AVERAGE function. Why did they do so? There might be some thought process behind it, right?
That's what we are digging into this week.
Scenario which we have taken here is, we have three different department files where
people have to update their department file by simply selecting their department in a drop down and clicking on a link.
Check out the attachments which illustrates how we solved this requirement using hyperlink function.
Hope this illustration would give you some idea, where you can make use of HYPERLINK function in your work.
Wish you a great week ahead...
With best regards,
Hariharan Ramakrishnan
Microsoft Office Applications Trainer / Consultant
From India, Chennai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
EXCEL FORMULA.xls