{"id":466,"date":"2018-01-16T17:13:27","date_gmt":"2018-01-16T09:13:27","guid":{"rendered":"http:\/\/excelchamp.net\/?p=466"},"modified":"2023-12-03T21:36:23","modified_gmt":"2023-12-03T13:36:23","slug":"viewing-the-formula-in-another-cell-in-excel","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/","title":{"rendered":"Viewing the Formula in Another Cell in Excel"},"content":{"rendered":"<p><span style=\"color: #ff0000;\"><em><strong>Applicable For:<\/strong> This tip works in Microsoft Excel 2013 &amp; Excel 2016, and Office Excel 365 (for both Windows &amp; Mac Editions)<\/em><\/span><\/p>\n<p>Prior to the Excel 2013 edition, to view all the formulas in a given worksheet in Excel, we had to use the <strong>View Formulas<\/strong> button, or use the <strong>nifty shortcut I highlighted<\/strong> in another post on this topic &#8211; <a href=\"http:\/\/excelchamp.net\/view-all-formulas-in-excel-with-a-single-click\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>View All Formulas in Excel with a Single Click<\/strong><\/a>.<\/p>\n<p>But from the Excel 2013 and onward editions (including Excel 2016 &#8211; for Windows &amp; for Mac), we have another better way to view the formulas used in calculations. This method is fantastic, because it allows you to see the formulas, without having to flip the switch, and see only values or only formulas.<\/p>\n<p>In this technique, the original values and formulas can stay where they are. We can simply use the newly introduced Excel function in a new cell, which will then show you the formula of any given cell pretty easily.<\/p>\n<p>This new function is called <span style=\"color: #ff0000;\"><strong><em>FORMULATEXT<\/em><\/strong><\/span>.<\/p>\n<p><strong>=FORMULATEXT(cell_reference to a cell containing a formula)<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/excelchamp.net\/wp-content\/uploads\/2018\/01\/FormulaText-Demo.gif\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-470\" src=\"https:\/\/i0.wp.com\/excelchamp.net\/wp-content\/uploads\/2018\/01\/FormulaText-Demo.gif?resize=595%2C502\" alt=\"FormulaText Demo from ExcelChamp.net - By Vinai Prakash\" width=\"595\" height=\"502\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>With this new function, you can see the formula within any other Excel cell, without flipping up the on\/off option. It allows you to see the value and see the formula, all at the same time. Much better than the chicken only or egg only options&#8230;<br \/>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"705\" class=\"elementor elementor-705 elementor-bc-flex-widget\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f5e9af elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f5e9af\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f6d494f\" data-id=\"f6d494f\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-db6834f elementor-widget elementor-widget-text-editor\" data-id=\"db6834f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div style=\"background-color: #ffffcc; color: black; border: thin Black; border-style: none; align = center; line-height: 27px; width: 95%; padding: 20px 30px 10px;\"><p style=\"text-align: center;\"><span style=\"color: #0000cd;\"><strong>Want to Improve Your Excel Skills?<\/strong><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">Learn the Key Features of Excel Quickly &amp; Easily, by <\/span><span style=\"color: #0000cd;\">Joining the<br \/> <a href=\"https:\/\/www.trueducate.com\/courses\/basic-excel-online\/\" target=\"_blank\" rel=\"noopener\"><u><strong>Online Training<\/strong> on <\/u><strong><u>Basic \/ Intermediate Excel<\/u>.<\/strong><\/a><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">To Get Most out of Excel, Learn the\u00a0 <b><u><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Pivot Table techniques in our<br \/> Pivot Table Masterclass Training<\/a><\/u><\/b><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\"><strong>!<\/strong><\/a><\/span><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t<br \/>\nThis has been specially great while teaching or showing off stuff to someone. Now you can use complex formulas, and the <strong><em>FormulaText<\/em><\/strong> function will show the formula, while the original value stays put, making it easier to understand the formula and its working, while having the value displayed directly.<\/p>\n\n<p>Great, simple tip. I hope you like it!<\/p>\n<p>Cheers,<br \/>\nVinai Prakash,<br \/>\n<strong><em>Founder: ExcelChamp.Net &#8211; Effective Tips to Simplify Excel, Every Day!<\/em><\/strong><\/p>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"514\" class=\"elementor elementor-514\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-14e69bc6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"14e69bc6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31f6f1ef\" data-id=\"31f6f1ef\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3b580a03 elementor-widget elementor-widget-heading\" data-id=\"3b580a03\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Are you facing any problem in using Excel?  Any Question?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2709bfb elementor-widget elementor-widget-text-editor\" data-id=\"2709bfb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong><span style=\"color: #ff9900;\"><span class=\"st\">You have come to the right place<\/span>. Tell us your needs. We&#8217;ll be glad to help you!<\/span><\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e758d36 elementor-button-align-center elementor-widget elementor-widget-form\" data-id=\"6e758d36\" data-element_type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"Quick Enquiry\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"514\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"6e758d36\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"ExcelChamp\" \/>\n\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-text elementor-field-group elementor-column elementor-field-group-field_1 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_1\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tName\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"text\" name=\"form_fields[field_1]\" id=\"form-field-field_1\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Name\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-field_2 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_2\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[field_2]\" id=\"form-field-field_2\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Email\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-textarea elementor-field-group elementor-column elementor-field-group-field_3 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_3\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tQuestion\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t<textarea class=\"elementor-field-textual elementor-field  elementor-size-sm\" name=\"form_fields[field_3]\" id=\"form-field-field_3\" rows=\"3\" placeholder=\"Question\" required=\"required\" aria-required=\"true\"><\/textarea>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-recaptcha_v3 elementor-field-group elementor-column elementor-field-group-field_9c3764f elementor-col-100 recaptcha_v3-bottomright\">\n\t\t\t\t\t<div class=\"elementor-field\" id=\"form-field-field_9c3764f\"><div class=\"elementor-g-recaptcha\" data-sitekey=\"6Let3GkeAAAAABfVEzbSL0GVAq2ejuG2VI3tGriG\" data-type=\"v3\" data-action=\"Form\" data-badge=\"bottomright\" data-size=\"invisible\"><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button type=\"submit\" class=\"elementor-button elementor-size-sm elementor-animation-grow\">\n\t\t\t\t\t\t<span >\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-align-icon-right elementor-button-icon\">\n\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-arrow-right\"><\/i>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Help Me Out<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t\n<h2>Additional Resources for Learning Excel &amp; Become A Pro<\/h2>\n<ol>\n<li><a href=\"https:\/\/www.excelchamp.net\/top-12-most-important-excel-functions\/\">Top 12 Most Important Excel Functions You Absolutely Must Know<\/a><\/li>\n<li><a href=\"https:\/\/www.excelchamp.net\/beginners-guide-to-microsoft-excel\/\">Excel Beginners Guide<\/a><\/li>\n<li><a href=\"https:\/\/www.excelchamp.net\/essentials\">Excel Essentials: From Beginner To Pro in Just 6 Weeks<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Applicable For: This tip works in Microsoft Excel 2013 &amp; Excel 2016, and Office Excel 365 (for both Windows &amp; Mac Editions) Prior to the Excel 2013 edition, to view all the formulas in a given worksheet in Excel, we had to use the View Formulas button, or use the nifty shortcut I highlighted in &#8230; <a title=\"Viewing the Formula in Another Cell in Excel\" class=\"read-more\" href=\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/\" aria-label=\"More on Viewing the Formula in Another Cell in Excel\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[10],"tags":[47,98],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Viewing the Formula in Another Cell in Excel - ExcelChamp<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Viewing the Formula in Another Cell in Excel - ExcelChamp\" \/>\n<meta property=\"og:description\" content=\"Applicable For: This tip works in Microsoft Excel 2013 &amp; Excel 2016, and Office Excel 365 (for both Windows &amp; Mac Editions) Prior to the Excel 2013 edition, to view all the formulas in a given worksheet in Excel, we had to use the View Formulas button, or use the nifty shortcut I highlighted in ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"ExcelChamp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-16T09:13:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:36:23+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/excelchamp.net\/wp-content\/uploads\/2018\/01\/FormulaText-Demo.gif\" \/>\n<meta name=\"author\" content=\"Vinai Prakash\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vinai Prakash\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/\"},\"author\":{\"name\":\"Vinai Prakash\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"headline\":\"Viewing the Formula in Another Cell in Excel\",\"datePublished\":\"2018-01-16T09:13:27+00:00\",\"dateModified\":\"2023-12-03T13:36:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/\"},\"wordCount\":334,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"keywords\":[\"Excel Formula Viewer\",\"view a formula in Excel\"],\"articleSection\":[\"Pivot Table\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/\",\"url\":\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/\",\"name\":\"Viewing the Formula in Another Cell in Excel - ExcelChamp\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/#website\"},\"datePublished\":\"2018-01-16T09:13:27+00:00\",\"dateModified\":\"2023-12-03T13:36:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excelchamp.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Viewing the Formula in Another Cell in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excelchamp.net\/#website\",\"url\":\"https:\/\/www.excelchamp.net\/\",\"name\":\"ExcelChamp\",\"description\":\"Solving Everyday Problems With Excel\",\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excelchamp.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\",\"name\":\"Vinai Prakash\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"width\":487,\"height\":720,\"caption\":\"Vinai Prakash\"},\"logo\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\"},\"description\":\"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.\",\"sameAs\":[\"https:\/\/ExcelChamp.Net\",\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\",\"https:\/\/www.linkedin.com\/in\/vinaiprakash\/\",\"https:\/\/www.youtube.com\/user\/ExcelChamp\"],\"url\":\"https:\/\/www.excelchamp.net\/author\/ppfdd\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Viewing the Formula in Another Cell in Excel - ExcelChamp","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Viewing the Formula in Another Cell in Excel - ExcelChamp","og_description":"Applicable For: This tip works in Microsoft Excel 2013 &amp; Excel 2016, and Office Excel 365 (for both Windows &amp; Mac Editions) Prior to the Excel 2013 edition, to view all the formulas in a given worksheet in Excel, we had to use the View Formulas button, or use the nifty shortcut I highlighted in ... Read more","og_url":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/","og_site_name":"ExcelChamp","article_publisher":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_author":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_published_time":"2018-01-16T09:13:27+00:00","article_modified_time":"2023-12-03T13:36:23+00:00","og_image":[{"url":"http:\/\/excelchamp.net\/wp-content\/uploads\/2018\/01\/FormulaText-Demo.gif"}],"author":"Vinai Prakash","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vinai Prakash","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/"},"author":{"name":"Vinai Prakash","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"headline":"Viewing the Formula in Another Cell in Excel","datePublished":"2018-01-16T09:13:27+00:00","dateModified":"2023-12-03T13:36:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/"},"wordCount":334,"commentCount":0,"publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"keywords":["Excel Formula Viewer","view a formula in Excel"],"articleSection":["Pivot Table"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/","url":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/","name":"Viewing the Formula in Another Cell in Excel - ExcelChamp","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/#website"},"datePublished":"2018-01-16T09:13:27+00:00","dateModified":"2023-12-03T13:36:23+00:00","breadcrumb":{"@id":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.excelchamp.net\/viewing-the-formula-in-another-cell-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excelchamp.net\/"},{"@type":"ListItem","position":2,"name":"Viewing the Formula in Another Cell in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.excelchamp.net\/#website","url":"https:\/\/www.excelchamp.net\/","name":"ExcelChamp","description":"Solving Everyday Problems With Excel","publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excelchamp.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba","name":"Vinai Prakash","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","width":487,"height":720,"caption":"Vinai Prakash"},"logo":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/"},"description":"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.","sameAs":["https:\/\/ExcelChamp.Net","https:\/\/www.facebook.com\/profile.php?id=100079767634794","https:\/\/www.linkedin.com\/in\/vinaiprakash\/","https:\/\/www.youtube.com\/user\/ExcelChamp"],"url":"https:\/\/www.excelchamp.net\/author\/ppfdd\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/466"}],"collection":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/comments?post=466"}],"version-history":[{"count":3,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/466\/revisions"}],"predecessor-version":[{"id":2543,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/466\/revisions\/2543"}],"wp:attachment":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/media?parent=466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/categories?post=466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/tags?post=466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}