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.

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:

1. Sales

Excel Hyperlinks: Buttons | MyExcelOnline

2. Costs

Excel Hyperlinks: Buttons | MyExcelOnline

3. Profit

Excel Hyperlinks: Buttons | MyExcelOnline

 

Excel Hyperlinks: Buttons | MyExcelOnline

DOWNLOAD WORKBOOK

 

STEP 1:  Go to Insert > Illustrations > Shapes > Any Rectangle Shape

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 2:  Create a rectangle and type SALES.  Update the formatting to make the text look bigger and centered.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 3:  While holding CTRL + SHIFT, drag your first button using left-click to instantly duplicate it. Do it twice.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 4:  Go to Format > Shape Style and pick the formatting you want. Do it for all buttons to differentiate them from one another.

Excel Hyperlinks: Buttons | MyExcelOnline

Make sure to change the text of the other buttons to COSTS and PROFIT.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 5:  We will now create the cell that our button will navigate to.

Select the blank cells beside the SALES table. Then select Home > Merge & Center

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 6:  Take note of the cell reference and copy this. For SALES this is cell A2.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 7:  Right click on the SALES Button and select Link.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 8:  Make sure Place in This Document is selected then place the cell reference A2. Press OK.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 9:  Do the same for COSTS.

Select the blank cells beside the COSTS table. Then select Home > Merge & Center

Take note of the cell reference and copy this. For COSTS this is cell A26.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 10:  Right click on the COSTS Button and select Link.

Make sure Place in This Document is selected then place the cell reference A26. Press OK.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 11:  Select the blank cells beside the PROFIT table. Then select Home > Merge & Center

Take note of the cell reference and copy this. For PROFIT this is cell A48.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 12: Right click on the PROFIT Button and select Link.

Make sure Place in This Document is selected then place the cell reference A48. Press OK.

Excel Hyperlinks: Buttons | MyExcelOnline

STEP 13:  Let’s freeze in place the top row that contains our buttons.

Go to View > Freeze Panes > Freeze Top Row

Excel Hyperlinks: Buttons | MyExcelOnline

Now try clicking on the buttons and you will be impressed with the instant navigation!

Excel Hyperlinks: Buttons | MyExcelOnline

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

Excel Hyperlinks: Buttons | MyExcelOnline