{"id":9168,"date":"2018-08-24T21:35:43","date_gmt":"2018-08-24T19:35:43","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=9168"},"modified":"2024-02-07T17:27:27","modified_gmt":"2024-02-07T16:27:27","slug":"create-a-named-range-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-named-range-in-excel\/","title":{"rendered":"Create a Named Range in Excel"},"content":{"rendered":"<p>Whenever I work with <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"spreadsheets\" data-wpil-keyword-link=\"linked\">spreadsheets<\/a>, there&#8217;s no escaping the fact that I have to work with a lot of ranges.<\/p>\n<p>Some of these ranges I have to reuse time and time again to create different calculations!<\/p>\n<p>Good thing there are <strong>Named Ranges<\/strong> in Excel!<\/p>\n<p>By using a <strong>Named Range<\/strong>, you can make your <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a> much easier to understand and maintain.<\/p>\n<p><em><strong>You can define a name for a cell range, function, constant, or table.<\/strong><\/em><\/p>\n<p>Let us work with the following table below.\u00a0 We want to populate the <strong>Euro Amounts<\/strong> and the <strong>Sum of the USD<\/strong> columns:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Named Range in Excel\"  class=\"alignnone size-full wp-image-9171\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-01.jpg\" alt=\"Create a Named Range in Excel\" width=\"677\" height=\"132\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-01.jpg 677w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-01-300x58.jpg 300w\" sizes=\"(max-width: 677px) 100vw, 677px\" \/><\/a><\/p>\n<p>Let us go over how to do this in the tutorial below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/c6E1GXwDUE8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Create-a-Named-Range-in-Excel.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0Let us create our first\u00a0<strong>Named Range.\u00a0<\/strong><\/p>\n<p>Highlight the USD Amounts and type in the\u00a0<strong>Name Box<\/strong> a name: <em><strong>Amounts<\/strong><\/em><\/p>\n<p>Make sure that there are no spaces.\u00a0 Press\u00a0<strong>Enter.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Named Range in Excel\"  class=\"alignnone size-full wp-image-9172\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-02.jpg\" alt=\"Create a Named Range in Excel\" width=\"701\" height=\"194\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-02.jpg 701w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-02-300x83.jpg 300w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Let us do the same to our <strong>Euro <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/spot-rate\/\" target=\"_blank\" rel=\"noopener\">Exchange Rate<\/a><\/strong>. Highlight the exchange rate, and type in the\u00a0<strong>Name Box\u00a0<\/strong>a name:\u00a0<em><strong>EuroRate<\/strong><\/em><\/p>\n<p>Press\u00a0<strong>Enter.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Named Range in Excel\"  class=\"alignnone size-full wp-image-9173\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-03.jpg\" alt=\"Create a Named Range in Excel\" width=\"701\" height=\"198\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-03.jpg 701w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-03-300x85.jpg 300w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0Let us see our Named Ranges in action!<\/p>\n<p>To calculate the <strong>Euro Amount column<\/strong>, type in: =<strong>A9 * EuroRate<\/strong>.<\/p>\n<p>This will use our <strong><em>EuroRate<\/em> <\/strong>Named Range!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Named Range in Excel\"  class=\"alignnone size-full wp-image-9174\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-04.jpg\" alt=\"Create a Named Range in Excel\" width=\"680\" height=\"139\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-04.jpg 680w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-04-300x61.jpg 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/a><\/p>\n<p>Drag your <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> below to the rest of the column to get the amounts calculated:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Named Range in Excel\"  class=\"alignnone size-full wp-image-9175\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-05.jpg\" alt=\"Create a Named Range in Excel\" width=\"699\" height=\"158\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-05.jpg 699w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-05-300x68.jpg 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span>\u00a0To calculate the sum of the <strong>Sum of USD<\/strong> <strong>column<\/strong>, type in: =<strong>SUM(Amounts)<\/strong>.<\/p>\n<p>This will use our <strong><em>Amounts<\/em> <\/strong>Named Range!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-06.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Named Range in Excel\"  class=\"alignnone size-full wp-image-9176\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-06.jpg\" alt=\"Create a Named Range in Excel\" width=\"703\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-06.jpg 703w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-06-300x69.jpg 300w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/a><\/p>\n<p>And now you have your total!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-07.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Named Range in Excel\"  class=\"alignnone size-full wp-image-9177\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-07.jpg\" alt=\"Create a Named Range in Excel\" width=\"701\" height=\"165\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-07.jpg 701w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-07-300x71.jpg 300w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span>\u00a0If you want to check all the Named Ranges you created, go to\u00a0<em><strong>Formulas &gt; Defined Names &gt; Name Manager<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-08.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Named Range in Excel\"  class=\"alignnone size-full wp-image-9178\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-08.jpg\" alt=\"Create a Named Range in Excel\" width=\"733\" height=\"132\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-08.jpg 733w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-08-300x54.jpg 300w\" sizes=\"(max-width: 733px) 100vw, 733px\" \/><\/a><\/p>\n<p>You can edit your Named Ranges in here or delete them as well.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-09.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Named Range in Excel\"  class=\"alignnone size-full wp-image-9179\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-09.jpg\" alt=\"Create a Named Range in Excel\" width=\"552\" height=\"432\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-09.jpg 552w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Create-a-Named-Range-in-Excel-09-300x235.jpg 300w\" sizes=\"(max-width: 552px) 100vw, 552px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><b>How to Create a Named Range in Excel<\/b><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"HLOOKUP Function in Excel: Introduction\"  class=\"alignnone wp-image-9146 size-large\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS-1024x683.jpg\" alt=\"HLOOKUP Function in Excel: Introduction\" width=\"1024\" height=\"683\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS-1024x683.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Blog_image_title_FORMULAS.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Whenever I work with spreadsheets, there&#8217;s no escaping the fact that I have to work with a lot of ranges. Some of these ranges I have to reuse time and time again to create different calculations! Good thing there are Named Ranges in Excel! By using a Named Range, you can make your formulas much [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17690,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,3,41,16,312],"tags":[88,107,467],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9168"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=9168"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9168\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17690"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=9168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=9168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=9168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}