{"id":991,"date":"2016-03-31T13:27:35","date_gmt":"2016-03-31T11:27:35","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=991"},"modified":"2024-04-06T19:47:53","modified_gmt":"2024-04-06T17:47:53","slug":"excel-hyperlinks-buttons","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-hyperlinks-buttons\/","title":{"rendered":"Excel Hyperlinks: Buttons"},"content":{"rendered":"

Excel\u00b4s hyperlink<\/a> capability is amazing but many people don’t use it as they don’t know its full capabilities.<\/p>\n

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.<\/p>\n

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

To have a better idea, this is how our workbook is setup, we have 3 main sections that we want the buttons to navigate to:<\/p>\n

1. Sales<\/p>\n

\"Excel<\/p>\n

2. Costs<\/p>\n

\"Excel<\/p>\n

3. Profit<\/p>\n

\"Excel<\/p>\n

 <\/p>\n