[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Excel spreadsheets can be used to organize data and structure it in a specific way for professional reporting. When you work with large datasets that span across many tabs, linking the data can be a great way to save time in your analysis. Moreover, you may want to link a specific cell or a full range to an external source, such as a website or another spreadsheet stored online.<\/p>\n
In Excel, users can include hyperlinks to create direct links between sheets or cells. If you want to know more about a specific cell or piece of information, you can click on it, and it will take you to the reference cell, sheet, or online source. Creating a hyperlink in Excel can be achieved by using the built-in command or the HYPERLINK function.<\/p>\n
In this article, you\u2019ll learn how to insert a hyperlink in Excel to create clickable links that will take you to another cell, sheet, or website. You\u2019ll also learn how to remove them in a few simple steps.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-to-insert-a-hyperlink-in-excel-betwe” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
In how to reference another sheet or workbook in Excel<\/a>, we offer multiple ways to pull data from another cell, a range of cells, or another sheet by establishing a reference. Similarly to this, creating a hyperlink allows you to link data contained in a cell or a range of cells in another sheet located in the same workbook.<\/p>\n 1.<\/strong> Select the cell where you want the hyperlink to be inserted. Here, I\u2019ve selected the cell containing \u201cPERSONNEL % OF TOTAL SALES\u201d. Here, I will link to another sheet in my workbook containing further information.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-select-cell.webp” alt=”Excel hyperlink \u2014 Channel Marketing Budget sheet with the PERSONNEL (% OF TOTAL SALES) cell selected” title_text=”Channel Marketing Budget sheet with the PERSONNEL (% OF TOTAL SALES) cell selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to Insert > Hyperlink. An alternative way is to right-click and select \u201cHyperlink\u201d from the drop-down menu, or simply use the Ctrl\/Cmd + K keyboard shortcut.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-right-click-menu.webp” alt=”Insert hyperlink in Excel \u2014 right-click menu on the selected cell with Hyperlink highlighted” title_text=”Right-click menu on the selected cell with Hyperlink highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> As you can see in the prompted window, you can link to a \u201cWeb Page or File\u201d, \u201cThis Document\u201d, or \u201cEmail Address\u201d. In this case, we\u2019ll select \u201cThis Document\u201d to link to another sheet in this same workbook.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-this-document-tab.webp” alt=”Excel hyperlink dialog \u2014 Insert Hyperlink window with the This Document tab selected” title_text=”Insert Hyperlink window with the This Document tab selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> To link to another sheet, go to \u201cOr select a place in this document\u201d option and click on the desired sheet. Click \u201cOK\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-to-another-sheet-ok.webp” alt=”Excel hyperlink to another sheet \u2014 PERSONNEL sheet selected under Cell Reference, with the OK button” title_text=”PERSONNEL sheet selected under Cell Reference, with the OK button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> As you can see below, the selected cell is now clickable and formatted as a hyperlink.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-between-sheets-result.webp” alt=”Excel hyperlink result \u2014 PERSONNEL (% OF TOTAL SALES) cell now underlined as a link” title_text=”PERSONNEL (% OF TOTAL SALES) cell now underlined as a link” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This is a great way to make your spreadsheet more interactive – by clicking on the hyperlinked cell, you will arrive at the related sheet automatically. Let\u2019s now see how you can link to another cell within the same sheet.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-insert-a-hyperlink-in-excel-to-an” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Inserting a hyperlink in Excel to link to another cell can be very useful in case your data spreads across many rows and columns. To avoid scrolling through all this data, you can insert a hyperlink in the following way.<\/p>\n 1.<\/strong> Select the cell where you want the hyperlink to be inserted. This time, I\u2019ve selected the cell \u201cPersonnel Total $(000)\u201d to link to the total amount, which is shown to the far right in column Q.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-to-cell-select-cell.webp” alt=”Hyperlink to another cell in Excel \u2014 Personnel Total $(000) cell selected in row 8″ title_text=”Personnel Total $(000) cell selected in row 8″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to Insert > Hyperlink or use any of the shortcut alternatives provided earlier. The same window as before is prompted. In this case, select the same sheet under the \u201cOr select a place in this document\u201d option and type in the cell reference you want to link to. Here, I have typed in \u201cQ8\u201d as it\u2019s the cell containing the related information, \u201c316.95\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-cell-reference-q8.webp” alt=”Excel hyperlink to a cell \u2014 Insert Hyperlink window with Q8 typed as the cell reference” title_text=”Insert Hyperlink window with Q8 typed as the cell reference” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Click \u201cOK\u201d to create the hyperlink.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-to-cell-result.webp” alt=”Excel cell hyperlink \u2014 Personnel Total $(000) cell now underlined as a link” title_text=”Personnel Total $(000) cell now underlined as a link” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This is a great way to save time when analyzing or reviewing large datasets. To keep your headers in view while you scroll, you can also freeze rows and columns in Excel<\/a>. So far, you\u2019ve seen how to insert a hyperlink using the built-in command feature, let\u2019s see how you can insert links using the HYPERLINK function in Excel.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-insert-a-hyperlink-in-excel-using” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n An alternative way to create hyperlinks in Excel is through the HYPERLINK function, which converts the selected data into a hyperlink format. This Excel formula allows you to build links to other workbooks, websites, or other files stored in servers. Let\u2019s start by using the HYPERLINK formula to link to another worksheet.<\/p>\n 1.<\/strong> Select the cell where you want to insert the HYPERLINK formula. Note that you will need to enter the formula in the cell, so remember the text that will be replaced with the formula. Here, I want the cell \u201cPERSONNEL % OF TOTAL SALES\u201d to link to another sheet name, \u201cPERSONNEL\u201d, containing further information.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-select-cell-2.webp” alt=”Excel hyperlink \u2014 Channel Marketing Budget sheet with the PERSONNEL (% OF TOTAL SALES) cell selected” title_text=”Channel Marketing Budget sheet with the PERSONNEL (% OF TOTAL SALES) cell selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Type in the equal sign and type HYPERLINK. Excel will prompt you with the correct formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-formula-type.webp” alt=”Excel HYPERLINK formula \u2014 HYPERLINK typed in the cell with the link_location and friendly_name hint” title_text=”HYPERLINK typed in the cell with the link_location and friendly_name hint” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Click on the \u201clink_location\u201d parameter and then on any cell in the sheet you want to link to. It automatically includes the sheet reference in the formula. Here, \u201cPERSONNEL!A1\u201d has been included to refer to the sheet \u201cPERSONNEL\u201d I will link to.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-formula-link-location.webp” alt=”Excel HYPERLINK formula \u2014 formula bar showing PERSONNEL!A1 as the link location” title_text=”Formula bar showing PERSONNEL!A1 as the link location” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> For \u201c[friendly_name]\u201d include the text you want the cell to show. Here, I will include the original text \u201cPERSONNEL % OF TOTAL SALES\u201d. Then, press \u201cEnter\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-formula-friendly-name.webp” alt=”Excel HYPERLINK formula \u2014 formula bar with PERSONNEL!A1 and the friendly name PERSONNEL % OF TOTAL SALES” title_text=”Formula bar with PERSONNEL!A1 and the friendly name PERSONNEL % OF TOTAL SALES” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The steps to hyperlink to another cell using the HYPERLINK formula are almost identical to linking between sheets. The only difference is that the \u201clink_location\u201d will include the cell reference. Here, I have used \u201cQ8\u201d following the same example shown before and included \u201cPersonnel Total $(000)\u201d for the \u201cfriendly_name\u201d parameter.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-formula-another-cell.webp” alt=”Excel HYPERLINK formula to another cell \u2014 formula bar with Q8 and the friendly name Personnel Total $(000)” title_text=”Formula bar with Q8 and the friendly name Personnel Total $(000)” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that you know various methods to make a hyperlink in Excel between sheets and to another cell, let\u2019s see how you can remove it.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-remove-a-hyperlink-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In case data is removed or you no longer wish to link specific data, here are the steps to remove hyperlinks in Excel.<\/p>\n 1.<\/strong> Select the hyperlinked cell(s) you want to remove and right-click on them. Click on \u201cRemove hyperlink\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-remove-right-click.webp” alt=”Remove hyperlink in Excel \u2014 right-click menu on the linked cell with Remove Hyperlink highlighted” title_text=”Right-click menu on the linked cell with Remove Hyperlink highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Another quick option is to go to Home > Clear > Clear Formats or Home > Clear > Remove Hyperlinks.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-hyperlink-clear-menu.webp” alt=”Clear hyperlinks in Excel \u2014 Home tab Clear menu with Clear Formats, Clear Hyperlinks and Remove Hyperlinks” title_text=”Home tab Clear menu with Clear Formats, Clear Hyperlinks and Remove Hyperlinks” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Both methods are applicable to removing single hyperlinks; however, if you create multiple hyperlinks in an Excel spreadsheet all at once, then the best way to remove them is to use a macro code<\/a>. This will delete all hyperlinks and leave them as unformatted text.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Hyperlinks are a super easy method to reference specific cells, sheets or files in large datasets. As they are links, your data can remain dynamic, and the rest of your spreadsheet will not be affected by any changes. This is particularly great in circumstances where you need to constantly change or update your data, or if you work on the same Excel file with multiple users.<\/p>\n In this article, you have learned how to create a hyperlink in Excel using the built-in command and the HYPERLINK function. Both allow you to create clickable data that will take you directly to another cell, sheet, or website. This is a great way to make your datasets more interactive and visual for users. If you only want to add context to a cell without sending readers somewhere else, add comments and notes in Excel<\/a> instead.<\/p>\n If you want to learn more about creating references to other data in Excel, read our blog article on how to reference another sheet or workbook in Excel<\/a>. If you prefer working with Google Sheets, you will find linking Google Sheets: How to reference another sheet<\/a> more useful. To add clickable links in Google Sheets itself, see how to insert a link in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda a inserir um hiperlink no Excel para outra planilha, c\u00e9lula ou site com o comando Inserir Hiperlink ou a fun\u00e7\u00e3o HYPERLINK, e como remov\u00ea-lo.<\/p>","protected":false},"author":2,"featured_media":265145,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[51],"tags":[],"class_list":["post-265129","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=265129"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265129\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/265145"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=265129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=265129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=265129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to insert a hyperlink in Excel to another cell?<\/h2>\n
How to insert a hyperlink in Excel using the HYPERLINK function?<\/h2>\n
How to hyperlink between sheets in Excel using the HYPERLINK formula?<\/h3>\n
How to hyperlink to another cell in Excel using the HYPERLINK formula?<\/h3>\n
How to remove a hyperlink in Excel?<\/h2>\n
Conclusion<\/h2>\n