{"id":366693,"date":"2021-11-13T23:00:30","date_gmt":"2021-11-13T20:00:30","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-link-to-cells-or-spreadsheets-in-google-sheets\/"},"modified":"2021-11-13T23:00:30","modified_gmt":"2021-11-13T20:00:30","slug":"how-to-link-to-cells-or-spreadsheets-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-link-to-cells-or-spreadsheets-in-google-sheets\/","title":{"rendered":"#How to Link to Cells or Spreadsheets in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 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-6a291cb5eee50\" 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-6a291cb5eee50\" 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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-link-to-cells-or-spreadsheets-in-google-sheets\/#How_to_Link_to_a_Group_of_Cells\" >How to Link to a Group of Cells<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-link-to-cells-or-spreadsheets-in-google-sheets\/#How_to_Link_to_a_Named_Group_of_Cells\" >How to Link to a Named Group of Cells<\/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-cells-or-spreadsheets-in-google-sheets\/#How_to_Link_to_Another_Sheet\" >How to Link to Another Sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-link-to-cells-or-spreadsheets-in-google-sheets\/#Copy_Edit_or_Remove_a_Link\" >Copy, Edit, or Remove a Link<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Link to Cells or Spreadsheets in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For an easy way to jump to a cell range or another spreadsheet, use hyperlinks. This is ideal for referencing data that you can view with a click. Here\u2019s how to link to cells and spreadsheets in Google Sheets.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Open Links in Google Sheets with a Single Click<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Link_to_a_Group_of_Cells\"><\/span>How to Link to a Group of Cells<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you have a large spreadsheet, you may want to link to a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/755108\/how-to-group-and-ungroup-rows-and-columns-in-google-sheets\/\">group of cells within it. This gives you a quick way to move to that group.<\/p>\n<p>Go to the cell where you want to add the link. You can enter text to use as the link here or in the pop-up window to come. Otherwise, the group of cells will <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>ear as the text.<\/p>\n<p>Click Insert &gt; Insert Link from the menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766487\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/InsertLink-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Insert, Insert Link\" width=\"230\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the window opens, click \u201cSheets and Named Ranges\u201d at the bottom.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766486\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SheetsNamedRanges-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Sheets and Named Ranges\" width=\"350\" height=\"274\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, scroll down once more and click \u201cSelect a Range of Cells to Link.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766485\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SelectRange-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Select a Range of Cells to Link\" width=\"350\" height=\"402\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In either of the above two steps, you can add the text you want to link in the box labeled Text at the top of the window. This is handy if you didn\u2019t enter it in the cell before you started the link process.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766488\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/AddText-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add text for the link\" width=\"350\" height=\"236\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Select a Data Range window appears, enter the cell range or drag through the range on your sheet to populate the box. Click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766484\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SelectDataRange-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select or enter the data range\" width=\"500\" height=\"219\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see your hyperlink in the cell. Select the cell and then click the link that appears in the tiny pop-up window. You\u2019ll head right to the data range you picked.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766489\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/LinkCellRange-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Linked cell range in Google Sheets\" width=\"611\" height=\"124\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Group and Ungroup Rows and Columns in Google Sheets<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Link_to_a_Named_Group_of_Cells\"><\/span>How to Link to a Named Group of Cells<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019ve defined a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/727905\/how-to-rename-columns-or-rows-in-google-sheets\/\">name for a group of cells, you can link to that as well. The process is similar as linking to unnamed cells as described above.<\/p>\n<p>Select the cell where you want to add the link and click Insert &gt; Insert Link from the menu. When the window opens, click \u201cSheets and Named Ranges.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766486\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SheetsNamedRanges-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Sheets and Named Ranges\" width=\"350\" height=\"274\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the subsequent pop-up, scroll down to the Name Ranges section and choose the one you want. You can also add the text for the cell here if needed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766490\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/NamedRanges-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a Named Range\" width=\"350\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see your hyperlink and when you select the cell, you can click the link in the small pop-up to go to the named cell range.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766491\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/LinkNamedRange-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Linked named cell range in Google Sheets\" width=\"300\" height=\"85\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Rename Columns or Rows in Google Sheets<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Link_to_Another_Sheet\"><\/span>How to Link to Another Sheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One more convenient way to use a hyperlink in Google Sheets is to link to another sheet. This process is even easier than the above processes for cell ranges.<\/p>\n<p>Select the cell where you want to add the link and click Insert &gt; Insert Link from the menu. If you see the sheet you want when the window appears, select it. If not, click \u201cSheets and Named Ranges.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766486\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SheetsNamedRanges-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Sheets and Named Ranges\" width=\"350\" height=\"274\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see a list of the spreadsheets in the workbook below Sheets. Simply choose the one you want. Again, you can add text at the top if you like.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766493\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/Sheets-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the sheet\" width=\"350\" height=\"402\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see the hyperlink and can click the link in the small pop-up window to go to the sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766492\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/LinkSheet-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Linked sheet in Google Sheets\" width=\"300\" height=\"63\" 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=\"Copy_Edit_or_Remove_a_Link\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Copy, Edit, or Remove a Link<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After you add a hyperlink, whether to a cell range or sheet, you can copy, edit, or <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/481429\/how-to-remove-hyperlinks-from-google-docs\/\">remove the link. Select the cell containing the link and choose the action on the right of the small pop-up window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-766494\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/CopyEditRemove-GoogleSheetsLinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Copy, edit, or remove a link\" width=\"300\" height=\"63\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you use Microsoft Excel in addition to Google Sheets, take a look at how to use cross references and named cells in Excel.<\/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\/766480\/how-to-link-to-cells-or-spreadsheets-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Link to Cells or Spreadsheets in Google Sheets&#8221; For an easy way to jump to a cell range or another spreadsheet, use hyperlinks. This is ideal for referencing data that you can view with a click. Here\u2019s how to link to cells and spreadsheets in Google Sheets. RELATED: How to Open Links in&#8230;<\/p>\n","protected":false},"author":1,"featured_media":366694,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-366693","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\/366693","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=366693"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/366693\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/366694"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=366693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=366693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=366693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}