{"id":1067,"date":"2022-11-30T15:49:17","date_gmt":"2022-11-30T15:49:17","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1067"},"modified":"2024-05-04T21:12:02","modified_gmt":"2024-05-04T21:12:02","slug":"how-to-create-named-range-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-create-named-range-in-excel\/","title":{"rendered":"How to create Named Range in Excel?"},"content":{"rendered":"<p>Named ranges in Excel offer a plethora of benefits, from organizing data to simplifying formulas and enhancing data validation. By utilizing named ranges, users can improve the clarity and efficiency of their spreadsheet workflows. Whether it&#8217;s for dynamic data selection, chart creation, or pivot table, excel table management, named ranges provide a flexible and intuitive way to work with data. With Named Range in Excel, users can unlock the full potential of their spreadsheets, ensuring accuracy and ease of use throughout their Excel projects.<\/p>\n<p><strong>This Tutorial Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#how-to-create-named-range-in-excel?-\/-how-do-you-make-a-named-range-in-excel?\"><strong>How to create Named Range in Excel? \/ How do you make a named range in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-name-a-range-in-excel?-\/-how-to-create-named-ranges-in-excel?\"><strong>How to Name a Range in Excel? \/ How to Create Named Ranges in Excel?<\/strong><\/a>\n<ul>\n<li>Method 1: By typing name in Name Box<\/li>\n<li>Method 2: By using Define Name Option<\/li>\n<li>Method 3: By using Name Manager Option<\/li>\n<li>Method 4: Using Create from Selection Option<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-manage-multiple-named-range?-\/-how-to-handle-multiple-named-ranges?\"><strong>How to manage multiple Named Range? \/ How to handle multiple named ranges?<\/strong><\/a>\n<ul>\n<li>Method 1: By getting the Names of all the Named Range<\/li>\n<li>Method 2: Displaying the Matching Named Ranges<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-edit-named-range-in-excel?-\/-How-to-modify-a-named-range-in-excel?\"><strong>How to Edit Named Range in Excel? \/ How to Modify a Named Range in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-delete-named-ranges-in-excel?-\/-how-to-remove-named-ranges-from-excel?\"><strong>How to Delete Named Ranges in Excel? \/ How to Remove Named Ranges from Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-create-a-dynamic-named-range-in-excel?-\/-creating-dynamic-named-ranges-in-excel\"><strong>How to create a dynamic named range in Excel? \/ Creating Dynamic Named Ranges in Excel<\/strong><\/a><\/li>\n<li><a href=\"#how-to-use-excel-named-ranges?\"><strong>How to Use Excel Named Ranges?<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"how-to-create-named-range-in-excel?-\/-how-do-you-make-a-named-range-in-excel?\">1. How do you create named range in Excel?<\/strong><\/h2>\n<p>A classic excel can have many different formulas and keeping track of all of the cell ranges used by those formulas can be difficult. To make it easier, users can give any cell range a more intuitive, descriptive name and then use those named ranges in their formulas. To create from selection in Excel, simply select a cell or select the range and type the name you want into the Name box to create a named range. Users can then utilize the new name to refer to that cell range at any time.<\/p>\n<h2><strong id=\"how-to-name-a-range-in-excel?-\/-how-to-create-named-ranges-in-excel?\">2. How to Name a Range in Excel? \/ Range Names in Excel.<\/strong><\/h2>\n<p>In Excel, there are four different ways to define a name:<\/p>\n<ul>\n<li>By typing name in Name Box<\/li>\n<li>By using Define Name Option<\/li>\n<li>By using Name Manager Option<\/li>\n<li>Using Create from Selection Option<\/li>\n<\/ul>\n<h3>2.1 Method 1: By typing name in Name Box<\/h3>\n<p>Below are the steps for using Name Box to create an Excel Named Range:<\/p>\n<p><strong>Step 1:<\/strong> Select a cell or a range of cells to name. Here we select cell A2:A7.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-1068 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-1.png\" alt=\"Named Range in Excel\" width=\"370\" height=\"226\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-1.png 370w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-1-300x183.png 300w\" sizes=\"(max-width: 370px) 100vw, 370px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Enter what you want to name as Named Range in the Name Box on the left of the Formula bar.<\/p>\n<figure id=\"attachment_1069\" aria-describedby=\"caption-attachment-1069\" style=\"width: 437px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"wp-image-1069 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-2.png\" alt=\"Named Range in Excel\" width=\"437\" height=\"258\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-2.png 437w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-2-300x177.png 300w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><figcaption id=\"caption-attachment-1069\" class=\"wp-caption-text\">Named Range in Excel<\/figcaption><\/figure>\n<p><strong>Step 3:<\/strong> Press the Enter.<\/p>\n<h3>2.2 Method 2: By using Define Name Option (define and use names)<\/h3>\n<p><strong>Step 1:<\/strong> Select a cell or a range of cells to name. Here we select cell B2:B7<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-1070 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-3.png\" alt=\"Named Range in Excel\" width=\"401\" height=\"242\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-3.png 401w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-3-300x181.png 300w\" sizes=\"(max-width: 401px) 100vw, 401px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Go to the Formulas tab, in the Define Names group, click on the Define Name button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1071 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-4.png\" alt=\"Named Range in Excel\" width=\"477\" height=\"192\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-4.png 477w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-4-300x121.png 300w\" sizes=\"(max-width: 477px) 100vw, 477px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Enter the following information in the New Name dialog box:<\/p>\n<ul>\n<li>Fill in the range name in the Name box.<\/li>\n<li>Set the name scope in the Scope dropdown (Workbook by default).<\/li>\n<li>Check the reference in the Refers to box and correct it if necessary.<\/li>\n<li>\n<p><figure id=\"attachment_1072\" aria-describedby=\"caption-attachment-1072\" style=\"width: 398px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1072 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-5.png\" alt=\"Named Range in Excel\" width=\"398\" height=\"302\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-5.png 398w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-5-300x228.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><figcaption id=\"caption-attachment-1072\" class=\"wp-caption-text\">Named Range in Excel<\/figcaption><\/figure><\/li>\n<\/ul>\n<p><strong>Step 4: <\/strong>Click OK.<\/p>\n<h3>2.3 Method 3: By using Name Manager Option<\/h3>\n<p><strong>Step 1:<\/strong> Select a cell or a range of cells to name.<\/p>\n<p><strong>Step 2:<\/strong> Go to the Formulas tab, in the Define Names group, click on the Name Manager. Keyboard Shortcut Ctrl + F3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1073 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-6.png\" alt=\"Named Range in Excel\" width=\"338\" height=\"181\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-6.png 338w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-6-300x161.png 300w\" sizes=\"(max-width: 338px) 100vw, 338px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Click the <strong>New&#8230;<\/strong> button in the upper left corner of the Name Manager dialog window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1074\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-7.png\" alt=\"Create Named Range\" width=\"640\" height=\"502\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-7.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-7-300x235.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 4:<\/strong> This brings up the New Name dialog box. Enter the following information in the New Name dialog box:<\/p>\n<ul>\n<li>Fill in the range name in the Name box.<\/li>\n<li>Set the name scope in the Scope dropdown (Workbook by default).<\/li>\n<li>Check the reference in the Refers to box and correct it if necessary.<\/li>\n<\/ul>\n<p><strong>Step 5: <\/strong>Click OK.<\/p>\n<p>2.4 Method 4: Using Create from Selection Option<\/p>\n<p><strong>Step 1:<\/strong> Select the whole table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1075\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-8.png\" alt=\"Create Named Range\" width=\"412\" height=\"250\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-8.png 412w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-8-300x182.png 300w\" sizes=\"(max-width: 412px) 100vw, 412px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Go to the Formulas tab, in the Define Names group, click on the Create from Selection. Keyboard Shortcut Ctrl + Shift + F3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1076\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-9.png\" alt=\"Create Named Range\" width=\"337\" height=\"185\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-9.png 337w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-9-300x165.png 300w\" sizes=\"(max-width: 337px) 100vw, 337px\" \/><\/p>\n<p><strong>Step 3: <\/strong>The Create Names from Selection dialog box will appear. Click OK after selecting the column or row with headers, or both.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1077 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-10.png\" alt=\"Named Range in Excel\" width=\"358\" height=\"243\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-10.png 358w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-10-300x204.png 300w\" sizes=\"(max-width: 358px) 100vw, 358px\" \/><\/p>\n<p>Excel will generate named ranges based on the names in the headers.<\/p>\n<h2><strong id=\"how-to-manage-multiple-named-range?-\/-how-to-handle-multiple-named-ranges?\">3. How to Manage multiple Name Manager in Excel?<\/strong><\/h2>\n<p>When working with large data sets and statistical models, users could find oneself producing a significant number of Named Ranges in Excel.<\/p>\n<p>3.1 Method 1: By getting the Names of all the Named Range<\/p>\n<p><strong>Step 1:<\/strong> Go to the Formulas tab, in the Define Names group, click on \u2018Use in Formula\u2019.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1078\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-11.png\" alt=\"Create Named Range\" width=\"328\" height=\"183\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-11.png 328w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-11-300x167.png 300w\" sizes=\"(max-width: 328px) 100vw, 328px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step 2: <\/strong>Select &#8216;Paste Names.&#8217;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1079\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-12.png\" alt=\"Create Named Range\" width=\"278\" height=\"207\" \/><\/p>\n<p>It thus returns a list of all the Named Ranges in that workbook. Double-click on a named range (in formulas or a cell) to use it. <em>Result outlined below:<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1080\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-13.png\" alt=\"Create Named Range\" width=\"342\" height=\"281\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-13.png 342w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-13-300x246.png 300w\" sizes=\"(max-width: 342px) 100vw, 342px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>3.2 Method 2: Displaying the Matching Named Ranges<\/p>\n<p>Try typing a few \ufb01rst characters, and Excel will display a drop-down list of names that match.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1081\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-14.png\" alt=\"Create Named Range\" width=\"175\" height=\"90\" \/><\/p>\n<h2><strong id=\"how-to-edit-named-range-in-excel?-\/-How-to-modify-a-named-range-in-excel?\">4. How to Edit Named Range in Excel? \/ How to Modify a Named Range in Excel?<\/strong><\/h2>\n<p><strong>Step 1:<\/strong> Go to the Formulas tab, in the Define Names group, click on the Name Manager. Keyboard Shortcut Ctrl + F3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1082\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-15.png\" alt=\"Create Named Range\" width=\"333\" height=\"182\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-15.png 333w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-15-300x164.png 300w\" sizes=\"(max-width: 333px) 100vw, 333px\" \/><\/p>\n<p><strong>Step 2: <\/strong>The Name Manager dialog box displays a list of all the Named Ranges in that workbook.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1084\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-16.png\" alt=\"Create Named Range\" width=\"571\" height=\"447\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-16.png 571w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-16-300x235.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Double-click the Named Range you want to modify. Or click on the Edit\u2026 Option. This will open the Edit Name dialog box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1083\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-17.png\" alt=\"Create Named Range\" width=\"402\" height=\"313\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-17.png 402w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-17-300x234.png 300w\" sizes=\"(max-width: 402px) 100vw, 402px\" \/><\/p>\n<p><strong>Step 4: <\/strong>Make the necessary changes in the Edit Name dialog box. Click OK after that.<\/p>\n<h2><strong id=\"how-to-delete-named-ranges-in-excel?-\/-how-to-remove-named-ranges-from-excel?\">5. How to Delete Named Ranges in Excel?\u00a0<\/strong><\/h2>\n<p><strong>Step 1:<\/strong> Go to the Formulas tab, in the Define Names group, click on the Name Manager.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1085\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-18.png\" alt=\"Create Named Range\" width=\"332\" height=\"182\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-18.png 332w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-18-300x164.png 300w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/p>\n<p><strong>Step 2: <\/strong>The Name Manager dialog box displays a list of all the Named Ranges in that workbook. Choose the one you want to remove.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1086\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-19.png\" alt=\"Create Named Range\" width=\"571\" height=\"446\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-19.png 571w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-19-300x234.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Click the Delete button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1087\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-20.png\" alt=\"Create Named Range\" width=\"568\" height=\"453\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-20.png 568w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-20-300x239.png 300w\" sizes=\"(max-width: 568px) 100vw, 568px\" \/><\/p>\n<h2><strong id=\"how-to-create-a-dynamic-named-range-in-excel?-\/-creating-dynamic-named-ranges-in-excel\">6. How to create a dynamic named range in Excel by formula? Dynamic Range.<\/strong><\/h2>\n<p>When you&#8217;re operating with a constantly changing data set, you might want to make your named range dynamic so that it expands to accommodate newly added entries and contracts for excluding removed data.<\/p>\n<p><strong>Step 1:<\/strong> Go to the Formulas tab, in the Define Names group, click on the Define Name button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1088\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-21.png\" alt=\"Create Named Range\" width=\"468\" height=\"188\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-21.png 468w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-21-300x121.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Enter the following information in the New Name dialog box:<\/p>\n<ul>\n<li>Fill in the range name in the Name box.<\/li>\n<li>Set the name scope in the Scope dropdown (Workbook by default).<\/li>\n<li>Refers to: =$A$2:INDEX($A$2:$A$50,COUNTIF($A$2:$A$50,\u201d&lt;&gt;\u201d&amp;\u201d\u201d))<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1089\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-22.png\" alt=\"Create Named Range\" width=\"527\" height=\"312\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-22.png 527w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/11\/Create-Named-Range-22-300x178.png 300w\" sizes=\"(max-width: 527px) 100vw, 527px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Click OK.<\/p>\n<h2><strong id=\"how-to-use-excel-named-ranges?\">7. How to Use Named Ranges in Excel?<\/strong><\/h2>\n<p>Upon generating names, users can use the named range as follows:<\/p>\n<ul>\n<li>Make Use of Names for Easy Navigation<\/li>\n<li>In Formulas, Use Names<\/li>\n<\/ul>\n<p><strong>Make Use of Names for Easy Navigation<\/strong><\/p>\n<p>When a name refers to a range, users can use the Name Box dropdown list to choose the named range on the worksheet.<\/p>\n<p><strong>In Formulas, Use Name Range Reference<\/strong><\/p>\n<p>Names can also be used in formulas. For instance, you could have a group of cells with Initial investment. Name those cells CASHFLOW, then use the following formula to calculate the total:<\/p>\n<p>=SUM(CASHFLOW)<\/p>\n<h2><strong>Application of\u00a0<\/strong>Named Range in Excel<\/h2>\n<ul>\n<li><strong>Data Organization<\/strong>: Named ranges help organize data by assigning meaningful labels to specific cell ranges, enhancing clarity and understanding.<\/li>\n<li><strong>Formula Clarity<\/strong>: Using named ranges in formulas improves formula readability and makes them easier to understand and maintain.<\/li>\n<li><strong>Dynamic Data Selection<\/strong>: Named ranges facilitate dynamic data selection, allowing users to easily reference data that may change in size or location.<\/li>\n<li><strong>Chart Creation<\/strong>: Named ranges simplify chart creation by providing descriptive labels for data series, axes, and titles. Use sheet name to apply name manager in the chart.<\/li>\n<li><strong>Data Validation<\/strong>: Named ranges can be used in data validation rules to restrict data entry to predefined lists or ranges, ensuring data accuracy.<\/li>\n<li><strong>Pivot Tables<\/strong>: Named ranges are useful in pivot tables for defining source data, making it easier to update and manage pivot tables as data changes.<\/li>\n<\/ul>\n<p><strong>For ready-to-use Dashboard Templates:<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Named ranges in Excel offer a plethora of benefits, from organizing data to simplifying formulas and enhancing data validation. By utilizing named ranges, users can improve the clarity and efficiency of their spreadsheet workflows. Whether it&#8217;s for dynamic data selection, chart creation, or pivot table, excel table management, named ranges provide a flexible and intuitive &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-create-named-range-in-excel\/\"> <span class=\"screen-reader-text\">How to create Named Range in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[172],"tags":[174,173,175],"class_list":["post-1067","post","type-post","status-publish","format-standard","hentry","category-named-range-in-excel","tag-create-named-range","tag-create-named-range-in-excel","tag-named-range-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=1067"}],"version-history":[{"count":10,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1067\/revisions"}],"predecessor-version":[{"id":9139,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1067\/revisions\/9139"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=1067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=1067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=1067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}