{"id":379,"date":"2011-10-10T20:28:31","date_gmt":"2011-10-10T20:28:31","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=379"},"modified":"2023-12-30T23:13:37","modified_gmt":"2023-12-30T23:13:37","slug":"using-named-ranges-and-the-name-manager","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/using-named-ranges-and-the-name-manager\/","title":{"rendered":"Excel 2010: Using Named Ranges and the Name Manager"},"content":{"rendered":"<p>For larger spreadsheets, Range Names are more convenient than scroll bars.\u00a0 To name an individual cell or block of cells highlight the cell or cells first, click on the <strong>Name Box<\/strong>, type in an appropriate name, and press the <strong>Enter<\/strong> key. (Range names do not accept spaces.)<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/RangeName.jpg\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-380\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/RangeName.jpg\" alt=\"Range Name list and selected area\" width=\"432\" height=\"419\" \/><\/a>To find the block again, use the drop-down list in the Name Box and click on the name. Alternatively use the <strong>GoTo<\/strong> command (Ctrl+G or F5). Note: Range names can also be used in formulae instead of their cell reference equivalent.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/GoTo.jpg\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-381\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/GoTo.jpg\" alt=\"GoTo window\" width=\"287\" height=\"269\" \/><\/a>To edit or delete range names, use the <strong>Name Manager<\/strong> from the <strong>Formulas<\/strong> tab. Note that the delete option only deletes the range name, and not the contents of the cells in that range.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For larger spreadsheets, Range Names are more convenient than scroll bars.\u00a0 To name an individual cell or block of cells highlight the cell or cells first, click on the Name Box, type in an appropriate name, and press the Enter key. (Range names do not accept spaces.) To find the block again, use the drop-down [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[173,350,376,449],"class_list":["post-379","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-2010","tag-managing-spreadsheets","tag-mjw","tag-ranges"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=379"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/379\/revisions"}],"predecessor-version":[{"id":6773,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/379\/revisions\/6773"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}