{"id":6312,"date":"2021-01-18T22:15:05","date_gmt":"2021-01-18T21:15:05","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6312"},"modified":"2024-03-22T18:54:10","modified_gmt":"2024-03-22T17:54:10","slug":"how-to-remove-formulas-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-formulas-in-excel\/","title":{"rendered":"3 Quick Ways to Remove Formulas in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/3-Quick-Ways-to-Remove-Formulas-in-Excel-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-33511\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/3-Quick-Ways-to-Remove-Formulas-in-Excel-1-1024x576.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/3-Quick-Ways-to-Remove-Formulas-in-Excel-1-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/3-Quick-Ways-to-Remove-Formulas-in-Excel-1-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/3-Quick-Ways-to-Remove-Formulas-in-Excel-1-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/3-Quick-Ways-to-Remove-Formulas-in-Excel-1.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><\/p>\n<p>There are times when I have an <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Excel worksheet full of formulas<\/a> and I want to hard code the results and Excel remove formula completely.<\/p>\n<p>This is very easy to do! Keep reading to know more.<\/p>\n<p>Removing formulas and keeping the data in Excel may be necessary because of the following reasons:<\/p>\n<ul>\n<li>You don&#8217;t require the value to be linked to any other cells and want to <strong>display just the value<\/strong>.<\/li>\n<li>It will help you <strong>speed up your workbook<\/strong>.<\/li>\n<li>You may <strong>have confidential information<\/strong> inside the formula that you don&#8217;t want to disclose and it is best to Excel remove formula.<\/li>\n<\/ul>\n<p>Whatever be the reason, sometimes it becomes extremely essential to remove formulas from your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/importing-excel-workbooks-power-pivot\/\" target=\"_blank\" rel=\"noopener\">Excel workbook<\/a> and show just the values.<\/p>\n<p>Here is our<strong> sample worksheet<\/strong> which has the following\u00a0formulas in <strong>Column E<\/strong>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6314 size-full\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01.jpg\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"479\" height=\"238\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01.jpg 479w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01-300x149.jpg 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/p>\n<p>Instead of showing the formula <strong>=REPLACE(D9, 1, FIND(&#8220;-&#8220;,D9), &#8220;&#8221;)<\/strong> in the address bar, you want the value i.e. the <strong>new phone number<\/strong> to be displayed.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-formulas-in-excel\/#Remove_Formula_using_Right_Click\" title=\"Remove Formula using Right Click\">Remove Formula using Right Click<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-formulas-in-excel\/#Remove_Formula_using_the_Home_Tab\" title=\"Remove Formula using the Home Tab\">Remove Formula using the Home Tab<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-formulas-in-excel\/#Find_Remove_Formula_using_Keyboard_Shortcuts\" title=\"Find &amp; Remove Formula using Keyboard Shortcuts\">Find &amp; Remove Formula using Keyboard Shortcuts<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-formulas-in-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Remove_Formula_using_Right_Click\"><\/span><span style=\"color: #339966;\"><a id=\"using-right-click\"><\/a>Remove Formula using Right Click<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Download this Excel Workbook and follow along to understand how to Excel remove formula from your worksheet:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">How-to-Remove-Formulas-in-Excel.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Select\u00a0all the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/lock-and-protect-formula-cells-in-excel\/\" target=\"_blank\" rel=\"noopener\">cells\u00a0that have formulas<\/a>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6314 size-full\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01.jpg\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"479\" height=\"238\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01.jpg 479w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01-300x149.jpg 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>Right click and select\u00a0<strong>Copy:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6315 size-full\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-02.jpg\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"364\" height=\"217\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-02.jpg 364w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-02-300x179.jpg 300w\" sizes=\"(max-width: 364px) 100vw, 364px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span>\u00a0Right click again and select <strong>Paste Values<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6316 size-full\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-03.jpg\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"320\" height=\"209\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-03.jpg 320w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-03-300x196.jpg 300w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><\/a><\/p>\n<p>Now you will see that the values are only retained and the formulas are now gone!<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Remove_Formula_using_the_Home_Tab\"><\/span><span style=\"color: #339966;\"><a id=\"using-the-home-tab\"><\/a>Remove Formula using the Home Tab<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Select all the cells that have formulas:<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22336 size-full\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01-1.jpg\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"479\" height=\"238\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01-1.jpg 479w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Remove-Formulas-in-Excel-01-1-300x149.jpg 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Go to the Home tab in the <b class=\"ocpUI\">Clipboard<\/b>\u00a0group, click the arrow below\u00a0<b class=\"ocpUI\">Paste<\/b> and then click Paste Values.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-48.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22385\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-48.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"454\" height=\"379\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-48.png 454w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-48-300x250.png 300w\" sizes=\"(max-width: 454px) 100vw, 454px\" \/><\/a><\/p>\n<p>Now, you will see that the <strong>cells don&#8217;t have formulas anymore<\/strong>. It has been <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/replace-values-using-power-query-in-excel\/\" target=\"_blank\" rel=\"noopener\">replaced by values<\/a>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-49.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22386\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-49.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"463\" height=\"290\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-49.png 463w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-49-300x188.png 300w\" sizes=\"(max-width: 463px) 100vw, 463px\" \/><\/a><\/p>\n<p>Lastly, you can <strong>even use keyboard shortcuts<\/strong> to convert formulas to value.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Find_Remove_Formula_using_Keyboard_Shortcuts\"><\/span><span style=\"color: #339966;\"><a id=\"using-excel-shortcuts\"><\/a>Find &amp; Remove Formula using Keyboard Shortcuts<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In the above scenarios, you already knew which cells contain formulas.<\/p>\n<p>Let&#8217;s go to an example where you have to <strong>first find the cells containing formulas<\/strong> and then learn <strong>how to remove formulas in Excel<\/strong> using keyboard shortcuts.<\/p>\n<p>In the data below, the sales price for some product have been calculated using formulas and some are constant values.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/Screenshot-53.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22484\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/Screenshot-53.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"346\" height=\"365\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/Screenshot-53.png 346w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/Screenshot-53-284x300.png 284w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/a>\u00a0 <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/Screenshot-54.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22483\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/Screenshot-54.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"353\" height=\"368\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/Screenshot-54.png 353w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/Screenshot-54-288x300.png 288w\" sizes=\"(max-width: 353px) 100vw, 353px\" \/><\/a><\/p>\n<p>You have to<strong> remove the formulas from your Excel Worksheet<\/strong>. Follow the<strong> steps below<\/strong> to learn how to remove formula in Excel shortcut:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Press <strong>Ctrl + G <\/strong>to open the Go To dialog box and then select <strong>Special<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-55.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22395\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-55.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"281\" height=\"269\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Select <strong>Formulas<\/strong> for the list and click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-56.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22396\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-56.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"314\" height=\"330\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-56.png 314w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-56-285x300.png 285w\" sizes=\"(max-width: 314px) 100vw, 314px\" \/><\/a><\/p>\n<p><em>All the cells containing formulas will be selected.<\/em><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Highlight these cells with color.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-57.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22397\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-57.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"596\" height=\"491\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-57.png 596w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-57-300x247.png 300w\" sizes=\"(max-width: 596px) 100vw, 596px\" \/><\/a><\/p>\n<p>The <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-cell-rules-based-on-text-labels\/\" target=\"_blank\" rel=\"noopener\">cells will be highlighted<\/a> in yellow!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-62.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22400\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-62.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"392\" height=\"361\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-62.png 392w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-62-300x276.png 300w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Press <strong>Ctrl + C<\/strong> to copy the cells.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-63.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22401\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-63.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"386\" height=\"364\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-63.png 386w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-63-300x283.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> Press <strong>Alt+E+S<\/strong> to open the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/paste-special-a-values-multiplier-in-excel\/\" target=\"_blank\" rel=\"noopener\">Paste Special<\/a> option dialog box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-59.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22403\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-59.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"398\" height=\"329\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-59.png 398w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-59-300x248.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> <strong>Press V<\/strong> to select values and click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-61.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22399\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-61.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"397\" height=\"329\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-61.png 397w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-61-300x249.png 300w\" sizes=\"(max-width: 397px) 100vw, 397px\" \/><\/a><\/p>\n<p>The formula has now been replaced with value.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-65.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22404\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-65.png\" alt=\"\" width=\"375\" height=\"362\" title=\"\"><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span> <strong>Repeat the same steps <\/strong>for other <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-cells-with-a-single-space-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">highlighted cells<\/a>.<\/p>\n<h3><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-65.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22404 size-full\" title=\"3 Quick Ways to Remove Formulas in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-65-e1610967625952.png\" alt=\"3 Quick Ways to Remove Formulas in Excel\" width=\"374\" height=\"321\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-65-e1610967625952.png 374w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-65-e1610967625952-300x257.png 300w\" sizes=\"(max-width: 374px) 100vw, 374px\" \/><\/a><\/h3>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"color: #339966;\">Conclusion<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are 3 ways in which you can <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a> remove formula using either right-click, home tab, or <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\">keyboard shortcuts<\/a>. This will help you to remove the formula without deleting the data.<\/p>\n<p>You can easily reduce the size of your file or <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-show-hide-formulas-in-excel\/\" target=\"_blank\" rel=\"noopener\">hide the formula<\/a> from recipients!<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Further learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/\" target=\"_blank\" rel=\"noopener\">How to Master Excel Formulas &#8211; The Ultimate Guide<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-formula-giving-wrong-answers\/\" target=\"_blank\" rel=\"noopener\">Why Excel Formula giving Wrong Answers?<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-apply-formula-to-entire-column\/\" target=\"_blank\" rel=\"noopener\">How to Apply Formula to Entire Column in Excel: Easiest Methods Explained<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<div>\n<style>.special-box a { color: #fff; } <\/style><div class=\"drop-shadow lifted special-box\" style=\"text-align: center; color: #fff; padding: 15px; background: var(--V4-primary-orange); border-radius: 6px;\">&#x1f449; <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Click Here To Join Our Free Formulas &amp; Functions Webinar Training on VLOOKUP, IF, SUMIF &amp; INDEX\/MATCH &amp; Advance Your Excel Level!<\/a><\/strong><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>There are times when I have an Excel worksheet full of formulas and I want to hard code the results and Excel remove formula completely. This is very easy to do! Keep reading to know more. Removing formulas and keeping the data in Excel may be necessary because of the following reasons: You don&#8217;t require [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":33511,"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,7,10,41,16],"tags":[256],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6312"}],"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=6312"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6312\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33511"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}