Excel has excellent features that make it possible to create spreadsheets with different purposes. One of these features is the use of hyperlinks, links that are designed to redirect the user to other spreadsheets or websites on the internet.
The feature can be used in very extensive spreadsheets with the addition of indexes, improving the organization and presentation of the documents, and the company's disclosure with the insertion of web addresses. Here is a step-by-step guide on how to create two types of hyperlink in excel.
Creating menus for your spreadsheets
In the following example, we created a menu for three different worksheets. Each excerpt displayed will be a hyperlink to the existing worksheet.
1 - Create a worksheet that contains the index for the other worksheets. To do this, right-click the tab in any of the spreadsheets and select the Insert option. You can also perform this action in the Excel header.
2 - In the new spreadsheet created, rename your Index tab. Then enter the texts and format the cells that will be the hyperlinks to the other worksheets. If you want, you can also use shapes (like buttons) following this same process. To add a shape, simply go to the Insert tab and choose the Shape option.
3 - Now, right-click on one of these cells (or shape). In the menu that appears, select the Hyperlink option.
4 - The Insert Hyperlink screen will be displayed.
5 - Select the Place this document option. Then select the spreadsheet tab you want to link to the previously selected cell.
6 - You can enter text that will be displayed when the mouse hover over the hyperlink to improve the preview. To do this, still on the Insert Hyperlink screen, click the ScreenTip button. Then type the text you want.
7 - Click OK. Your first hyperlink will be created! Repeat the procedure for the other cells that will be the index of the table.
8 - Ready! Clicking on any of the excerpts displays the linked tab.
Note that when you do this process, instead of looking at the list of tabs at the bottom of your spreadsheet, you can quickly and conveniently reach any tab on your spreadsheet with just one click and not much searching.
Creating Hyperlinks to Web Pages
Excel also has the option of creating hyperlinks to web addresses. This feature is very simple to implement in your spreadsheet, making it more complete and attractive.
You will want to use this kind of functionality when you want to refer to a blog post or when you want to make a product or service announcement. If you want, you can use this type of link in your spreadsheet attached to any image, cell or shape. See how to do it:
1 - Let's use as an example a free demonstration worksheet from LUZ. It should contain a hyperlink to the spreadsheet page (in this case, strategic planning sheet) that you want to post. To create it, first enter the text and format the cell that will be linked to the hyperlink (see that we put a red cell to draw attention and explain that this version is demonstrative and, if, who is seeing the worksheet wants the full version , you can buy it by accessing the link).
2 - Then right-click on the cell and select the Hyperlink option.
3 - Select the Web Page option. Then, in the Address field, enter the address that you want to link to and click Ok.
4 - Your hyperlink is ready! Now just format as you see fit. By clicking on it, you will be redirected to the newly linked page.
See how easy it is to create menus and insert hyperlinks? These small details will make all the difference in your table. Do you have any questions or suggestions? Leave a Reply