Excel´s hyperlink capability is amazing but many people don’t use it as they don’t know its full capabilities.

With a hyperlink you can link an object/text to open an existing file on your desktop, go to a website, open up an email to a specific contact or go to a cell within your workbook.

I will show you in the example below how you can create a hyperlink in a shape and then click on the shape to go to a specific report within your workbook without the need to scroll.

DOWNLOAD WORKBOOK

Hyperlink Buttons

 

Helpful Resource:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel Table: Row Calculations One of the most powerful feature of an Excel Table is the use of formulas to calculate its Column contents.  To activate this you need to click in your Table and go to the Table Tools tab in the Ribbon.  From there you simply need to activate the Total Rows check box. This wil...
Use Excel Goal Seek To Find The Formula Result You... If you have a formula and want to show a specific result, but you do not know what input values to change within the formula, then Excel's Goal Seek feature is the one for you. Imagine you are calculating the payment terms on a loan. Your PMT formula gives you an amount of ...
Text To Columns: Dates Whenever you download data from an external ERP system like Oracle, SAP, etc, you can have data that is not formatted the way you and Excel likes. Sometimes "Date" values are downloaded as "Text", so you cannot sort in the periodic date format. No worries!  Text to Columns ...
Copy The Cell Above In Excel Sometimes we get data that is downloaded from an external source and it is not formatted properly. You may have cells with missing data and cases where you want to copy the cell directly above to fill in your empty cell in Excel. This can be achieved with the following step...