{"id":235110,"date":"2024-04-22T04:24:15","date_gmt":"2024-04-22T04:24:15","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=235110"},"modified":"2024-04-22T04:24:15","modified_gmt":"2024-04-22T04:24:15","slug":"how-to-copy-a-value-not-the-formula-in-excel","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/","title":{"rendered":"How to copy a value not the formula in Excel?"},"content":{"rendered":"<p>Copying values in Excel can sometimes be tricky, especially when you don&#8217;t want to carry over formulas along with the data. When you copy and paste cells in Excel, it typically copies both the value and the formula. However, there are several ways you can copy just the value and leave the formula behind. Here are some methods you can use to copy a value, not the formula in Excel:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey 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\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#1_Paste_Special\" title=\"1. Paste Special\">1. Paste Special<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#2_Use_the_Copy_and_Paste_Values_Shortcut\" title=\"2. Use the Copy and Paste Values Shortcut\">2. Use the Copy and Paste Values Shortcut<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#3_Drag_and_Drop_with_the_Right_Mouse_Button\" title=\"3. Drag and Drop with the Right Mouse Button\">3. Drag and Drop with the Right Mouse Button<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#4_Use_the_Fill_Handle\" title=\"4. Use the Fill Handle\">4. Use the Fill Handle<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#5_Use_the_VALUE_Function\" title=\"5. Use the VALUE Function\">5. Use the VALUE Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#6_Convert_Formulas_to_Values_with_a_Macro\" title=\"6. Convert Formulas to Values with a Macro\">6. Convert Formulas to Values with a Macro<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#7_Use_the_Save_As_Values_Feature\" title=\"7. Use the Save As Values Feature\">7. Use the Save As Values Feature<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#8_Paste_Values_Directly_From_the_Clipboard\" title=\"8. Paste Values Directly From the Clipboard\">8. Paste Values Directly From the Clipboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#9_Use_the_TRANSPOSE_Function\" title=\"9. Use the TRANSPOSE Function\">9. Use the TRANSPOSE Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#10_Convert_Formulas_to_Static_Values_Manually\" title=\"10. Convert Formulas to Static Values Manually\">10. Convert Formulas to Static Values Manually<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#11_Use_the_TEXT_Function\" title=\"11. Use the TEXT Function\">11. Use the TEXT Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#12_Use_a_Helper_Column\" title=\"12. Use a Helper Column\">12. Use a Helper Column<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Paste_Special\"><\/span>1. Paste Special<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One of the easiest ways to copy a value, not the formula in Excel, is to use the Paste Special feature. After copying the cell with the formula, right-click on the destination cell, go to Paste Special, and select &#8220;Values&#8221; from the options. This will paste only the value of the cell without the formula.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Use_the_Copy_and_Paste_Values_Shortcut\"><\/span>2. Use the Copy and Paste Values Shortcut<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can also use a shortcut to copy and paste just the values in Excel. After copying the cell with the formula, instead of using the regular paste shortcut (Ctrl + V), use the paste values shortcut (Ctrl + Alt + V) and then press V again for values.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Drag_and_Drop_with_the_Right_Mouse_Button\"><\/span>3. Drag and Drop with the Right Mouse Button<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another method to copy a value, not the formula in Excel, is to use the drag-and-drop feature with the right mouse button. Simply drag the cell with the formula while holding down the right mouse button and drop it where you want to paste the value. Then, select &#8220;Copy Here as Values Only&#8221; from the context menu.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Use_the_Fill_Handle\"><\/span>4. Use the Fill Handle<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can also use the fill handle to copy values in Excel. After selecting the cell with the formula, hover over the fill handle (small square at the bottom-right corner of the cell) until the cursor changes to a black cross. Then, drag the fill handle to the desired destination cells, and when you release the mouse button, select &#8220;Values&#8221; from the options.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_Use_the_VALUE_Function\"><\/span>5. Use the VALUE Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to copy a value from a cell that is the result of a formula, you can use the VALUE function to convert the result to a static value. Simply enter =VALUE(cell_reference) in a new cell, where cell_reference is the cell containing the formula you want to convert. This will display the value of the cell without the formula.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"6_Convert_Formulas_to_Values_with_a_Macro\"><\/span>6. Convert Formulas to Values with a Macro<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you have a large number of cells with formulas that you want to convert to values, you can use a macro to automate the process. You can record a macro that copies the formulas as values or write a VBA script to achieve the same result.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"7_Use_the_Save_As_Values_Feature\"><\/span>7. Use the Save As Values Feature<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another way to copy values in Excel is to use the Save As feature. Simply save your Excel file as a new file with a different name, and choose &#8220;Values&#8221; as the file type. This will save a copy of your file with all formulas converted to values.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"8_Paste_Values_Directly_From_the_Clipboard\"><\/span>8. Paste Values Directly From the Clipboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you copy a cell with a formula, you can paste its value directly from the clipboard. After copying the cell, go to the destination cell and right-click to select the &#8220;Paste Values&#8221; option. This will paste only the value of the copied cell without the formula.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"9_Use_the_TRANSPOSE_Function\"><\/span>9. Use the TRANSPOSE Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to copy values from a formula that returns an array, you can use the TRANSPOSE function to convert the array into a row or column of values. Enter =TRANSPOSE(formula) in a new cell, where formula is the formula that returns an array, and press Enter. This will display the values in a single row or column.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"10_Convert_Formulas_to_Static_Values_Manually\"><\/span>10. Convert Formulas to Static Values Manually<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you only need to convert a few formulas to values, you can do it manually by copying the cell with the formula, right-clicking on the destination cell, selecting &#8220;Paste Special,&#8221; and choosing &#8220;Values.&#8221; This will paste the value of the cell without the formula.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"11_Use_the_TEXT_Function\"><\/span>11. Use the TEXT Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can also use the TEXT function to copy values in a specific format. Enter =TEXT(cell,&#8221;format&#8221;) in a new cell, where cell is the cell containing the value you want to copy and &#8220;format&#8221; is the desired format (e.g., #,##0). This will display the value of the cell in the specified format.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"12_Use_a_Helper_Column\"><\/span>12. Use a Helper Column<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If none of the above methods work for your specific scenario, you can always use a helper column to copy values. Simply enter a formula in the helper column that references the cell you want to copy the value from, and then copy and paste the helper column values to the desired location.<\/p>\n<p>By using these techniques, you can copy values in Excel without carrying over the formulas, making your data more manageable and easier to work with. Remember to choose the method that best suits your needs and practice using it to become more efficient in Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Copying values in Excel can sometimes be tricky, especially when you don&#8217;t want to carry over formulas along with the data. When you copy and paste cells in Excel, it typically copies both the value and the formula. However, there are several ways you can copy just the value and leave the formula behind. Here &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to copy a value not the formula in Excel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#more-235110\">Read more<span class=\"screen-reader-text\">How to copy a value not the formula in Excel?<\/span><\/a><\/p>\n","protected":false},"author":59,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-235110","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to copy a value not the formula in Excel?<\/title>\n<meta name=\"description\" content=\"Copying values in Excel can sometimes be tricky, especially when you don&#039;t want to carry over formulas along with the data. When you copy and paste cells\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to copy a value not the formula in Excel?\" \/>\n<meta property=\"og:description\" content=\"Copying values in Excel can sometimes be tricky, especially when you don&#039;t want to carry over formulas along with the data. When you copy and paste cells\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-22T04:24:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Francis French\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Francis French\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/\"},\"author\":{\"name\":\"Francis French\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\"},\"headline\":\"How to copy a value not the formula in Excel?\",\"datePublished\":\"2024-04-22T04:24:15+00:00\",\"dateModified\":\"2024-04-22T04:24:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/\"},\"wordCount\":826,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/\",\"name\":\"How to copy a value not the formula in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-04-22T04:24:15+00:00\",\"dateModified\":\"2024-04-22T04:24:15+00:00\",\"description\":\"Copying values in Excel can sometimes be tricky, especially when you don't want to carry over formulas along with the data. When you copy and paste cells\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to copy a value not the formula in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\",\"name\":\"Francis French\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Francis French\"},\"description\":\"Guest author Francis French has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to copy a value not the formula in Excel?","description":"Copying values in Excel can sometimes be tricky, especially when you don't want to carry over formulas along with the data. When you copy and paste cells","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:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to copy a value not the formula in Excel?","og_description":"Copying values in Excel can sometimes be tricky, especially when you don't want to carry over formulas along with the data. When you copy and paste cells","og_url":"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-04-22T04:24:15+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Francis French","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Francis French","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/"},"author":{"name":"Francis French","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48"},"headline":"How to copy a value not the formula in Excel?","datePublished":"2024-04-22T04:24:15+00:00","dateModified":"2024-04-22T04:24:15+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/"},"wordCount":826,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/","url":"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/","name":"How to copy a value not the formula in Excel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-04-22T04:24:15+00:00","dateModified":"2024-04-22T04:24:15+00:00","description":"Copying values in Excel can sometimes be tricky, especially when you don't want to carry over formulas along with the data. When you copy and paste cells","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-a-value-not-the-formula-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to copy a value not the formula in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48","name":"Francis French","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Francis French"},"description":"Guest author Francis French has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/59"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=235110"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235110\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=235110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=235110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=235110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}