{"id":499912,"date":"2022-10-10T21:00:00","date_gmt":"2022-10-10T18:00:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-link-to-another-sheet-in-microsoft-excel\/"},"modified":"2022-10-10T21:00:00","modified_gmt":"2022-10-10T18:00:00","slug":"how-to-link-to-another-sheet-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-link-to-another-sheet-in-microsoft-excel\/","title":{"rendered":"#How to Link to Another Sheet in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a3a121ea7942\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a3a121ea7942\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-link-to-another-sheet-in-microsoft-excel\/#%E2%80%9CHow_to_Link_to_Another_Sheet_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Link to Another Sheet in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-link-to-another-sheet-in-microsoft-excel\/#Link_to_Another_Sheet_in_an_Excel_Workbook\" >Link to Another Sheet in an Excel Workbook<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-link-to-another-sheet-in-microsoft-excel\/#Edit_or_Remove_a_Link_in_Excel\" >Edit or Remove a Link in Excel<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Link_to_Another_Sheet_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Link to Another Sheet in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\"\/><\/p>\n<p>Just like linking to another place in a Word document, you can link to another sheet in an Excel workbook. This is a handy way to quickly jump to a spreadsheet related to your current sheet or cell.<\/p>\n<p>Maybe you have a yearly budget with separate sheets for each month. Maybe you have a company workbook with a different sheet for each division. Or maybe you simply have a large workbook with dozens and dozens of sheets.<span class=\"Apple-converted-space\">\u00a0<\/span><\/p>\n<p>You can make it easy for yourself or those you\u2019re collaborating with to see the data on another sheet with just one click.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Link_to_Another_Sheet_in_an_Excel_Workbook\"><\/span>Link to Another Sheet in an Excel Workbook<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can link a specific cell to another sheet whether that cell contains text, numbers, or even a formula.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Cross Reference Cells Between Microsoft Excel Spreadsheets<\/em><\/strong><\/p>\n<p>Choose the cell you want to link. Either go to the Insert tab and select Links &gt; Insert link or right-click the cell and move your cursor to Link &gt; Insert Link.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-828278\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/LinkInsertLink-ExcelLinkToSheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Insert Link in the Link pop-out menu\" width=\"380\" height=\"334\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Insert Hyperlink window opens, choose \u201cPlace in This Document\u201d on the left. To the right, you\u2019ll see Cell Reference and Defined Names. Expand Cell Reference, if necessary, by clicking the plus sign.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-828279\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/ExpandCellReference-ExcelLinkToSheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Expand Cell Reference to see the sheet list\" width=\"650\" height=\"302\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see a list of the sheets in your workbook. From top to bottom the list shows sheets from left to right in the sheet tab row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-828280\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/SheetListTabRow-ExcelLinkToSheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sheet list and tab row\" width=\"650\" height=\"321\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select the sheet you want to link to which highlights it. If you simply want to link to the sheet, you can leave the \u201cType the Cell Reference\u201d field at the default cell A1. This is the top left cell in the sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-828282\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/ChooseSheet-ExcelLinkToSheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sheet selected with the default cell\" width=\"650\" height=\"302\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>But, if you want to link to a particular cell in the spreadsheet, enter the cell reference in that box instead.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-828281\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/ChooseSheetCell-ExcelLinkToSheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sheet selected with a certain cell\" width=\"650\" height=\"303\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish, click \u201cOK\u201d to <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ly the link to the cell. Then, give it a click! You should jump directly to the other sheet, or cell within it if you designated one.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-828284\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/CellLinked-ExcelLinkToSheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Cell linked to a sheet in Excel\" width=\"260\" height=\"173\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Edit_or_Remove_a_Link_in_Excel\"><\/span>Edit or Remove a Link in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After you add a link to another sheet, you may want to edit or remove it. Maybe you decide to link to a different cell or sheet, or simply delete the link altogether.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Remove Hyperlinks in Microsoft Excel<\/em><\/strong><\/p>\n<p>Right-click the cell containing the link and pick \u201cEdit Hyperlink\u201d to make a change or \u201cRemove Hyperlink\u201d to delete the link.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-828283\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/08\/EditRemoveLink-ExcelLinkToSheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Edit Hyperlink and Remove Hyperlink in the shortcut menu\" width=\"380\" height=\"348\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll notice that you can open the link using the right-click shortcut menu as well.<\/p>\n<p>Because it\u2019s so easy to link to another sheet in an Excel workbook, it\u2019s worth a minute or two to set it up if it saves you time from navigating to the sheet later\u2014especially if you have to scroll through the sheet tab bar to find it.<\/p>\n<p>For more, look at how to link to another document in your Excel spreadsheet.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/828275\/how-to-link-to-another-sheet-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Link to Another Sheet in Microsoft Excel&#8221; Just like linking to another place in a Word document, you can link to another sheet in an Excel workbook. This is a handy way to quickly jump to a spreadsheet related to your current sheet or cell. Maybe you have a yearly budget with separate&#8230;<\/p>\n","protected":false},"author":1,"featured_media":499913,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-499912","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/499912","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=499912"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/499912\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/499913"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=499912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=499912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=499912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}