{"id":235573,"date":"2024-04-16T01:02:16","date_gmt":"2024-04-16T01:02:16","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=235573"},"modified":"2024-04-16T01:02:16","modified_gmt":"2024-04-16T01:02:16","slug":"how-to-drag-same-value-in-excel-2","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/","title":{"rendered":"How to drag same value in Excel?"},"content":{"rendered":"<p>Have you ever needed to drag the same value across multiple cells in an Excel spreadsheet? Whether it&#8217;s a date, a number, or any other type of data, there&#8217;s a simple trick that allows you to easily fill in multiple cells with the same value. In this article, we&#8217;ll show you how to drag the same value in Excel with just a few simple steps.<\/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-drag-same-value-in-excel-2\/#Instructions\" title=\"Instructions:\">Instructions:<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#FAQs\" title=\"FAQs:\">FAQs:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#1_Can_I_drag_the_same_value_vertically_in_Excel\" title=\"1. Can I drag the same value vertically in Excel?\">1. Can I drag the same value vertically in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#2_Can_I_drag_the_same_value_to_non-adjacent_cells\" title=\"2. Can I drag the same value to non-adjacent cells?\">2. Can I drag the same value to non-adjacent cells?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#3_What_happens_if_I_drag_the_same_value_over_existing_data\" title=\"3. What happens if I drag the same value over existing data?\">3. What happens if I drag the same value over existing data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#4_Can_I_drag_the_same_value_to_multiple_rows_at_once\" title=\"4. Can I drag the same value to multiple rows at once?\">4. Can I drag the same value to multiple rows at once?<\/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-drag-same-value-in-excel-2\/#5_Is_there_a_shortcut_key_for_dragging_the_same_value_in_Excel\" title=\"5. Is there a shortcut key for dragging the same value in Excel?\">5. Is there a shortcut key for dragging the same value 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-drag-same-value-in-excel-2\/#6_How_can_I_drag_a_formula_instead_of_a_value\" title=\"6. How can I drag a formula instead of a value?\">6. How can I drag a formula instead of a value?<\/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-drag-same-value-in-excel-2\/#7_Can_I_drag_the_same_value_across_multiple_worksheets\" title=\"7. Can I drag the same value across multiple worksheets?\">7. Can I drag the same value across multiple worksheets?<\/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-drag-same-value-in-excel-2\/#8_Is_there_a_way_to_drag_the_same_value_without_using_the_mouse\" title=\"8. Is there a way to drag the same value without using the mouse?\">8. Is there a way to drag the same value without using the mouse?<\/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-drag-same-value-in-excel-2\/#9_Can_I_drag_the_same_value_diagonally_in_Excel\" title=\"9. Can I drag the same value diagonally in Excel?\">9. Can I drag the same value diagonally 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-drag-same-value-in-excel-2\/#10_Can_I_drag_the_same_value_in_Excel_Online\" title=\"10. Can I drag the same value in Excel Online?\">10. Can I drag the same value in Excel Online?<\/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-drag-same-value-in-excel-2\/#11_Can_I_drag_the_same_value_in_Excel_for_Mac\" title=\"11. Can I drag the same value in Excel for Mac?\">11. Can I drag the same value in Excel for Mac?<\/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-drag-same-value-in-excel-2\/#12_How_can_I_undo_a_drag-fill_operation_in_Excel\" title=\"12. How can I undo a drag-fill operation in Excel?\">12. How can I undo a drag-fill operation in Excel?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Instructions\"><\/span>Instructions:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Start by entering the value you want to drag into the first cell.<br \/>\n2. Hover your mouse over the lower-right corner of the cell until you see a small square.<br \/>\n3. Click and hold the square, then drag it across the cells where you want the same value to appear.<br \/>\n4. Release the mouse button to fill in the selected cells with the same value.<\/p>\n<p><b>How to drag same value in Excel?<\/b> By dragging the small square from the lower-right corner of a cell across other cells, you can easily fill them with the same value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_I_drag_the_same_value_vertically_in_Excel\"><\/span>1. Can I drag the same value vertically in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, the same method can be used to drag the same value vertically in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Can_I_drag_the_same_value_to_non-adjacent_cells\"><\/span>2. Can I drag the same value to non-adjacent cells?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can drag the same value to non-adjacent cells by selecting the cells before dragging the value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_What_happens_if_I_drag_the_same_value_over_existing_data\"><\/span>3. What happens if I drag the same value over existing data?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf you drag the same value over existing data, it will replace the existing values in the cells.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Can_I_drag_the_same_value_to_multiple_rows_at_once\"><\/span>4. Can I drag the same value to multiple rows at once?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can drag the same value to multiple rows at once by selecting the desired range of cells before dragging.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Is_there_a_shortcut_key_for_dragging_the_same_value_in_Excel\"><\/span>5. Is there a shortcut key for dragging the same value in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use the &#8220;Ctrl+D&#8221; shortcut key to fill down the same value in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_How_can_I_drag_a_formula_instead_of_a_value\"><\/span>6. How can I drag a formula instead of a value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo drag a formula instead of a value, simply enter the formula in the first cell and drag it across other cells as usual.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Can_I_drag_the_same_value_across_multiple_worksheets\"><\/span>7. Can I drag the same value across multiple worksheets?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can drag the same value across multiple worksheets by switching between the sheets and dragging the value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Is_there_a_way_to_drag_the_same_value_without_using_the_mouse\"><\/span>8. Is there a way to drag the same value without using the mouse?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use the &#8220;Ctrl&#8221; key along with the arrow keys to select cells and then use the &#8220;Ctrl+Enter&#8221; shortcut to fill them with the same value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_drag_the_same_value_diagonally_in_Excel\"><\/span>9. Can I drag the same value diagonally in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the drag-fill feature in Excel only allows dragging values horizontally and vertically, not diagonally.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Can_I_drag_the_same_value_in_Excel_Online\"><\/span>10. Can I drag the same value in Excel Online?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can drag the same value in Excel Online using the same method as in the desktop version.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Can_I_drag_the_same_value_in_Excel_for_Mac\"><\/span>11. Can I drag the same value in Excel for Mac?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can drag the same value in Excel for Mac using the same method as in the Windows version.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_How_can_I_undo_a_drag-fill_operation_in_Excel\"><\/span>12. How can I undo a drag-fill operation in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo undo a drag-fill operation in Excel, you can use the &#8220;Ctrl+Z&#8221; shortcut key to revert back to the original values before dragging.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever needed to drag the same value across multiple cells in an Excel spreadsheet? Whether it&#8217;s a date, a number, or any other type of data, there&#8217;s a simple trick that allows you to easily fill in multiple cells with the same value. In this article, we&#8217;ll show you how to drag the &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to drag same value in Excel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#more-235573\">Read more<span class=\"screen-reader-text\">How to drag same value 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-235573","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 drag same value in Excel?<\/title>\n<meta name=\"description\" content=\"Have you ever needed to drag the same value across multiple cells in an Excel spreadsheet? Whether it&#039;s a date, a number, or any other type of data,\" \/>\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-drag-same-value-in-excel-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to drag same value in Excel?\" \/>\n<meta property=\"og:description\" content=\"Have you ever needed to drag the same value across multiple cells in an Excel spreadsheet? Whether it&#039;s a date, a number, or any other type of data,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/\" \/>\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-16T01:02:16+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=\"3 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-drag-same-value-in-excel-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/\"},\"author\":{\"name\":\"Francis French\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\"},\"headline\":\"How to drag same value in Excel?\",\"datePublished\":\"2024-04-16T01:02:16+00:00\",\"dateModified\":\"2024-04-16T01:02:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/\"},\"wordCount\":527,\"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-drag-same-value-in-excel-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/\",\"name\":\"How to drag same value in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-04-16T01:02:16+00:00\",\"dateModified\":\"2024-04-16T01:02:16+00:00\",\"description\":\"Have you ever needed to drag the same value across multiple cells in an Excel spreadsheet? Whether it's a date, a number, or any other type of data,\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to drag same value 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 drag same value in Excel?","description":"Have you ever needed to drag the same value across multiple cells in an Excel spreadsheet? Whether it's a date, a number, or any other type of data,","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-drag-same-value-in-excel-2\/","og_locale":"en_US","og_type":"article","og_title":"How to drag same value in Excel?","og_description":"Have you ever needed to drag the same value across multiple cells in an Excel spreadsheet? Whether it's a date, a number, or any other type of data,","og_url":"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-04-16T01:02:16+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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/"},"author":{"name":"Francis French","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48"},"headline":"How to drag same value in Excel?","datePublished":"2024-04-16T01:02:16+00:00","dateModified":"2024-04-16T01:02:16+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/"},"wordCount":527,"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-drag-same-value-in-excel-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/","url":"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/","name":"How to drag same value in Excel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-04-16T01:02:16+00:00","dateModified":"2024-04-16T01:02:16+00:00","description":"Have you ever needed to drag the same value across multiple cells in an Excel spreadsheet? Whether it's a date, a number, or any other type of data,","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-drag-same-value-in-excel-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to drag same value 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\/235573","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=235573"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235573\/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=235573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=235573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=235573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}