{"id":152,"date":"2021-06-30T18:43:23","date_gmt":"2021-06-30T18:43:23","guid":{"rendered":"https:\/\/excelforgbs.com\/?p=152"},"modified":"2021-06-30T18:51:52","modified_gmt":"2021-06-30T18:51:52","slug":"cell-reference-across-sheets","status":"publish","type":"post","link":"https:\/\/excelforgbs.com\/?p=152","title":{"rendered":"Cell reference across sheets"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Cell references get a bit more complex when using cells from other sheets, but they can be created with the mouse, and formulas can be copied to access multiple cells across sheets.  Named ranged become even more useful when using multiple sheets for a model.<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/excelforgbs.com\/video\/Cells\/SheetCellReference.mp4\"><\/video><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Cell references get a bit more complex when using cells from other sheets, but they can be created with the mouse, and formulas can be copied to access multiple cells across sheets. Named ranged become even more useful when using multiple sheets for a model.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","_monsterinsights_skip_tracking":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-152","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=152"}],"version-history":[{"count":2,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts\/152\/revisions"}],"predecessor-version":[{"id":155,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts\/152\/revisions\/155"}],"wp:attachment":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}