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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Pivot Table Conditional Formatting Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot TableAdding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second.See how easy it is to add some color to your analysis.DOWNLOAD WORKBOOK...
Pivot Table Count Transactions The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count.This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit.DOWNLOAD...
Row Differences If you have two rows that you want to compare, for example, sale amount versus amount paid, you can easily filter the differences between these two columns by going in to the Find & Select > Go To Special > Row Differences.Once the cells have been identified, you ca...
Filter & Search The Search box within the Filter button is powerful if you know how to use it to your advantage.For example, if you had a list of customers the Search box allows you to find specific customers by typing in a few letters only, allows you to add a selection to your filtered lis...