{"id":235214,"date":"2024-06-17T11:34:12","date_gmt":"2024-06-17T11:34:12","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=235214"},"modified":"2024-06-17T11:34:12","modified_gmt":"2024-06-17T11:34:12","slug":"how-to-copy-the-value-not-the-formula-in-excel","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/","title":{"rendered":"How to copy the value not the formula in Excel?"},"content":{"rendered":"<p>Copying values instead of formulas in Excel can be a common need when you want to transfer data without altering the underlying calculations. While Excel typically copies both the value and the formula by default, there are several ways to only copy the value. Here&#8217;s how:<\/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-the-value-not-the-formula-in-excel\/#Method_1_Paste_Special\" title=\"Method 1: Paste Special\">Method 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-the-value-not-the-formula-in-excel\/#Method_2_Drag_and_Drop\" title=\"Method 2: Drag and Drop\">Method 2: Drag and Drop<\/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-the-value-not-the-formula-in-excel\/#Method_3_Using_the_Fill_Handle\" title=\"Method 3: Using the Fill Handle\">Method 3: Using the Fill Handle<\/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-the-value-not-the-formula-in-excel\/#Method_4_Using_the_Value_Function\" title=\"Method 4: Using the Value Function\">Method 4: Using the Value Function<\/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-the-value-not-the-formula-in-excel\/#Related_FAQs\" title=\"Related FAQs:\">Related FAQs:<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#1_Can_I_copy_values_without_altering_the_source_data_in_Excel\" title=\"1. Can I copy values without altering the source data in Excel?\">1. Can I copy values without altering the source data in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#2_How_can_I_copy_only_the_formatting_of_a_cell_in_Excel\" title=\"2. How can I copy only the formatting of a cell in Excel?\">2. How can I copy only the formatting of a cell in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#3_Is_there_a_way_to_copy_values_between_workbooks_in_Excel\" title=\"3. Is there a way to copy values between workbooks in Excel?\">3. Is there a way to copy values between workbooks in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#4_Can_I_copy_values_without_copying_the_number_formatting_in_Excel\" title=\"4. Can I copy values without copying the number formatting in Excel?\">4. Can I copy values without copying the number formatting in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#5_How_can_I_copy_values_without_copying_the_borders_and_cell_styles_in_Excel\" title=\"5. How can I copy values without copying the borders and cell styles in Excel?\">5. How can I copy values without copying the borders and cell styles in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#6_Is_there_a_way_to_copy_values_without_copying_conditional_formatting_in_Excel\" title=\"6. Is there a way to copy values without copying conditional formatting in Excel?\">6. Is there a way to copy values without copying conditional formatting in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#7_Can_I_copy_values_without_copying_the_column_width_in_Excel\" title=\"7. Can I copy values without copying the column width in Excel?\">7. Can I copy values without copying the column width in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#8_How_can_I_copy_only_the_visible_cells_in_a_filtered_range_in_Excel\" title=\"8. How can I copy only the visible cells in a filtered range in Excel?\">8. How can I copy only the visible cells in a filtered range in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#9_Is_there_a_shortcut_key_to_paste_values_in_Excel\" title=\"9. Is there a shortcut key to paste values in Excel?\">9. Is there a shortcut key to paste values in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#10_Can_I_copy_values_without_copying_the_comments_in_Excel\" title=\"10. Can I copy values without copying the comments in Excel?\">10. Can I copy values without copying the comments in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#11_How_can_I_copy_values_without_copying_hyperlinks_in_Excel\" title=\"11. How can I copy values without copying hyperlinks in Excel?\">11. How can I copy values without copying hyperlinks in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#12_Is_there_a_way_to_copy_values_without_copying_data_validation_in_Excel\" title=\"12. Is there a way to copy values without copying data validation in Excel?\">12. Is there a way to copy values without copying data validation in Excel?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_Paste_Special\"><\/span>Method 1: Paste Special<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The most straightforward way to copy values instead of formulas in Excel is by using the Paste Special feature. Here&#8217;s how you can do it:<\/p>\n<p>1. Select the cell or range of cells that contain the data you want to copy.<br \/>\n2. Right-click on the selection and choose &#8220;Copy&#8221; or press Ctrl + C on your keyboard.<br \/>\n3. Right-click on the destination cell or range where you want to paste the values.<br \/>\n4. Click on the &#8220;Paste Special&#8221; option.<br \/>\n5. In the Paste Special dialog box, choose &#8220;Values&#8221; and click OK.<\/p>\n<p>By following these steps, you are copying only the values without the formulas associated with them.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_Drag_and_Drop\"><\/span>Method 2: Drag and Drop<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another way to copy values instead of formulas is by using the drag-and-drop method. Here&#8217;s how you can do it:<\/p>\n<p>1. Select the cell or range of cells that contain the data you want to copy.<br \/>\n2. Move your cursor to the border of the selection until you see a four-sided arrow cursor.<br \/>\n3. Hold down the Ctrl key on your keyboard.<br \/>\n4. Drag the selection to the destination cell or range where you want to paste the values.<br \/>\n5. Release the Ctrl key and the mouse button.<\/p>\n<p>By holding down the Ctrl key while dragging and dropping, you are instructing Excel to copy only the values.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_3_Using_the_Fill_Handle\"><\/span>Method 3: Using the Fill Handle<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can also copy values instead of formulas using the fill handle feature in Excel. Here&#8217;s how you can do it:<\/p>\n<p>1. Select the cell that contains the data you want to copy.<br \/>\n2. Move your cursor to the bottom-right corner of the selection until you see a small square known as the fill handle.<br \/>\n3. Click and drag the fill handle to the destination cells where you want to paste the values.<\/p>\n<p>By dragging the fill handle to the destination cells, Excel will copy only the values without the formulas.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_4_Using_the_Value_Function\"><\/span>Method 4: Using the Value Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to copy values from a formula without changing the original formula, you can use the VALUE function. Here&#8217;s how you can do it:<\/p>\n<p>1. Enter the formula in a cell to calculate the desired value.<br \/>\n2. In another cell, use the formula =VALUE(cell) where &#8220;cell&#8221; is the reference to the cell containing the original formula.<br \/>\n3. Press Enter to get the value extracted from the formula.<\/p>\n<p>By using the VALUE function, you can copy the value generated by a formula without copying the formula itself.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Related_FAQs\"><\/span>Related FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_I_copy_values_without_altering_the_source_data_in_Excel\"><\/span>1. Can I copy values without altering the source data in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can copy values without altering the source data by using the Paste Special feature in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_can_I_copy_only_the_formatting_of_a_cell_in_Excel\"><\/span>2. How can I copy only the formatting of a cell in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo copy only the formatting of a cell, you can use the Format Painter feature in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Is_there_a_way_to_copy_values_between_workbooks_in_Excel\"><\/span>3. Is there a way to copy values between workbooks in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can copy values between workbooks by opening both workbooks and using the Paste Special feature.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Can_I_copy_values_without_copying_the_number_formatting_in_Excel\"><\/span>4. Can I copy values without copying the number formatting in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can copy values without copying the number formatting by choosing the &#8220;Values&#8221; option in the Paste Special dialog box.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_How_can_I_copy_values_without_copying_the_borders_and_cell_styles_in_Excel\"><\/span>5. How can I copy values without copying the borders and cell styles in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo copy values without copying the borders and cell styles, you can use the Paste Special feature and select only the &#8220;Values&#8221; option.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Is_there_a_way_to_copy_values_without_copying_conditional_formatting_in_Excel\"><\/span>6. Is there a way to copy values without copying conditional formatting in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can copy values without copying conditional formatting by using the Paste Special feature and choosing the &#8220;Values&#8221; option.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Can_I_copy_values_without_copying_the_column_width_in_Excel\"><\/span>7. Can I copy values without copying the column width in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can copy values without copying the column width by adjusting the column width after pasting the values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_How_can_I_copy_only_the_visible_cells_in_a_filtered_range_in_Excel\"><\/span>8. How can I copy only the visible cells in a filtered range in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo copy only the visible cells in a filtered range, you can use the Paste Special feature and select the &#8220;Values&#8221; option.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Is_there_a_shortcut_key_to_paste_values_in_Excel\"><\/span>9. Is there a shortcut key to paste values in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use the shortcut key Ctrl + Alt + V to open the Paste Special dialog box and choose the &#8220;Values&#8221; option to paste values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Can_I_copy_values_without_copying_the_comments_in_Excel\"><\/span>10. Can I copy values without copying the comments in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can copy values without copying comments by using the Paste Special feature and selecting only the &#8220;Values&#8221; option.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_How_can_I_copy_values_without_copying_hyperlinks_in_Excel\"><\/span>11. How can I copy values without copying hyperlinks in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo copy values without copying hyperlinks, you can use the Paste Special feature and choose the &#8220;Values&#8221; option.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Is_there_a_way_to_copy_values_without_copying_data_validation_in_Excel\"><\/span>12. Is there a way to copy values without copying data validation in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can copy values without copying data validation by using the Paste Special feature and selecting only the &#8220;Values&#8221; option.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Copying values instead of formulas in Excel can be a common need when you want to transfer data without altering the underlying calculations. While Excel typically copies both the value and the formula by default, there are several ways to only copy the value. Here&#8217;s how: Method 1: Paste Special The most straightforward way to &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to copy the value not the formula in Excel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#more-235214\">Read more<span class=\"screen-reader-text\">How to copy the 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-235214","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 the value not the formula in Excel?<\/title>\n<meta name=\"description\" content=\"Copying values instead of formulas in Excel can be a common need when you want to transfer data without altering the underlying calculations. While Excel\" \/>\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-the-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 the value not the formula in Excel?\" \/>\n<meta property=\"og:description\" content=\"Copying values instead of formulas in Excel can be a common need when you want to transfer data without altering the underlying calculations. While Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-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-06-17T11:34:12+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-the-value-not-the-formula-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/\"},\"author\":{\"name\":\"Francis French\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\"},\"headline\":\"How to copy the value not the formula in Excel?\",\"datePublished\":\"2024-06-17T11:34:12+00:00\",\"dateModified\":\"2024-06-17T11:34:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/\"},\"wordCount\":833,\"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-the-value-not-the-formula-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/\",\"name\":\"How to copy the value not the formula in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-06-17T11:34:12+00:00\",\"dateModified\":\"2024-06-17T11:34:12+00:00\",\"description\":\"Copying values instead of formulas in Excel can be a common need when you want to transfer data without altering the underlying calculations. While Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-copy-the-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 the 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 the value not the formula in Excel?","description":"Copying values instead of formulas in Excel can be a common need when you want to transfer data without altering the underlying calculations. While Excel","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-the-value-not-the-formula-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to copy the value not the formula in Excel?","og_description":"Copying values instead of formulas in Excel can be a common need when you want to transfer data without altering the underlying calculations. While Excel","og_url":"https:\/\/namso-gen.co\/blog\/how-to-copy-the-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-06-17T11:34:12+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-the-value-not-the-formula-in-excel\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/"},"author":{"name":"Francis French","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48"},"headline":"How to copy the value not the formula in Excel?","datePublished":"2024-06-17T11:34:12+00:00","dateModified":"2024-06-17T11:34:12+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/"},"wordCount":833,"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-the-value-not-the-formula-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/","url":"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/","name":"How to copy the value not the formula in Excel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-06-17T11:34:12+00:00","dateModified":"2024-06-17T11:34:12+00:00","description":"Copying values instead of formulas in Excel can be a common need when you want to transfer data without altering the underlying calculations. While Excel","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-copy-the-value-not-the-formula-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-copy-the-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 the 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\/235214","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=235214"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235214\/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=235214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=235214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=235214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}