Let us try and understand this with the help of an example. Consider the following spreadsheet. It consists of basic employee information.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/name1.png” alt=”Name Ranges or Cells in Google Sheets: Employee Information” title_text=”sample-data-in-google-sheets” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.21.2″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
We will name the range of cells\u00a0<\/span>C2:C11<\/strong>\u00a0<\/span>(i.e. the Age column). So we select them, and navigate to Data > Named ranges. Since these cells hold the age-related values, we will name this range as Age<\/strong>, and click on the\u00a0<\/span>Done<\/strong>\u00a0<\/span>button.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/name2.png” alt=”Name Ranges or Cells In Google Sheets: Named Ranges Toolbar in Google Sheets” title_text=”named-ranges-toolbar” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.21.2″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Similarly, let us add another named range, that represents the entire employee table. To do so, we select the cells\u00a0<\/span>A2:D11<\/strong>, on the\u00a0<\/span>Named ranges<\/strong>\u00a0<\/span>sidebar, we click on\u00a0<\/span>Add a range<\/strong>. Now we key in\u00a0the name\u00a0<\/span>Employee_Information<\/strong>\u00a0and click on the\u00a0<\/span>Done<\/strong>\u00a0<\/span>button.<\/p>\n Let us experiment these new named ranges within formulas and validate them against those that use primitive range reference notations.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/name3.png” alt=”Name Ranges or Cells in Google Sheets” title_text=”name-ranges-cells” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As we will notice, the formulas give the exact same results in both the cases. However, using the named ranges within the formulas gives it more meaningful interpretation.<\/p>\n We may want to edit or remove the named ranges in the future. We can access these options by clicking on the\u00a0<\/span>Edit<\/strong>\u00a0<\/span>(pencil) icon.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/name4.png” alt=”Name Ranges or Cells In google Sheets: Snapshot of Edit Option in Named Ranges Toolbar” title_text=”edit-option-in-toolbar” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.21.2″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Learn in this blog post how to import ranges from one sheet to the other in Google Sheets with the\u00a0<\/span>IMPORTRANGE<\/a>\u00a0 formula.<\/a><\/em><\/span><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Spreadsheets are made up of cells that can hold many types of data. And they usually are referenced using the R1C1 notation, for e.g. B4, or N6. And a group of cells is referenced in this notation R1C1:R2C2, for e.g. B2:C6. In practice, we use such references to individual cells or a group of cells […]<\/p>\n","protected":false},"author":40,"featured_media":7682,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Spreadsheets are made up of cells that can hold many types of data. And they usually are referenced using the R1C1 notation, for e.g. B4, or N6. And a group of cells is referenced in this notation R1C1:R2C2, for e.g. B2:C6. In practice, we use such references to individual cells or a group of cells within formulas, but they can get cumbersome. Fortunately, we can name ranges or cells in Google Sheets.\nWhy name ranges or cells in Google Sheets?<\/h3>\nThere are notable advantages when we refer ranges by names than when we use the primitive notations as discussed above.\n
\n \t
![\"Name](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/name1.png\")
\n\nWe will name the range of cells C2:C11<\/strong> (i.e. the Age column). So we select them, and navigate to Data > Named ranges. Since these cells hold the 'Age' related values, we will name this range as 'Age<\/strong>', and click on the Done<\/strong> button.\n\nExample<\/strong> ![\"Name](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/name2.png\")
\n\nSimilarly, let us add another named range, that represents the entire employee table. To do so, we select the cells A2:D11<\/strong>, on the Named ranges<\/strong> sidebar, we click on Add a range<\/strong>. Now we key in the name Employee_Information<\/strong> and click on the Done<\/strong> button.\n\nLet us experiment these new named ranges within formulas and validate them against those that use primitive range reference notations.\n\nExample<\/strong> ![\"Name](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/name3.png\")
\n\nAs we will notice, the formulas give the exact same results in both the cases. However, using the named ranges within the formulas gives it more meaningful interpretation.\n\nWe may want to edit or remove the named ranges in the future. We can access these options by clicking on the Edit<\/strong> (pencil) icon.\n\nExample<\/strong> ![\"Name](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/name4.png\")
\n\n
\n\nFeatured image designed by evening_tao \/ Freepik<\/a><\/em><\/span>","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7557","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/7557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=7557"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/7557\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/7682"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=7557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=7557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=7557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}