{"id":5619,"date":"2016-12-07T16:00:18","date_gmt":"2016-12-07T15:00:18","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5619"},"modified":"2023-11-30T21:02:00","modified_gmt":"2023-11-30T20:02:00","slug":"power-right-click-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/power-right-click-excel\/","title":{"rendered":"The Power of Right Click In Excel"},"content":{"rendered":"<p><strong>This is a guest post by Puneet Gogia from <a href=\"http:\/\/excelchamps.com\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">ExcelChamps<\/a>.<\/strong><\/p>\n<p>Have you ever heard about Excel&#8217;s drag &amp; drop menu?<\/p>\n<p>If you haven&#8217;t, then it&#8217;s alright because this is one of the most unused options in excel that I ever found.<\/p>\n<p>This option is super helpful for those who are more dependent on their mouse.<\/p>\n<p>So, today I&#8217;ll show you how to use this hidden power tool.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Power of Right Click In Excel\"  class=\"alignnone size-full wp-image-5621\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu.png\" alt=\"The Power of Right Click In Excel\" width=\"202\" height=\"272\" \/><\/a><\/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 class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/power-right-click-excel\/#Steps_To_Use_Drag_Drop_Menu\" title=\"Steps To Use Drag Drop Menu\">Steps To Use Drag Drop Menu<\/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\/power-right-click-excel\/#Other_Options_You_Have\" title=\"Other Options You Have\">Other Options You Have<\/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\/power-right-click-excel\/#Over_To_You\" title=\"Over To You\">Over To You<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Steps_To_Use_Drag_Drop_Menu\"><\/span><span style=\"color: #ff0000;\">Steps To Use Drag Drop Menu<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Using this drag drop menu is super easy. You just need few clicks.<\/p>\n<p>Let&#8217;s say you want to move your data from one section to another section. All you have to do.<\/p>\n<p>1. Select your data.<\/p>\n<p>2. Go to the edge of your selection (Thick Border).<\/p>\n<p>3. Right click &amp; hold.<\/p>\n<p>4. Now by holding your mouse, drag &amp; drop it to the place where you want to move it.<\/p>\n<p>5. And, when you drop it, you&#8217;ll get a menu. Select &#8220;Move Here&#8221; from the menu.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/move-data-with-excel-drag-drop-menu.gif\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5632\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/move-data-with-excel-drag-drop-menu.gif\" alt=\"move-data-with-excel-drag-drop-menu\" width=\"464\" height=\"380\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Other_Options_You_Have\"><\/span><span style=\"color: #ff0000;\">Other Options You Have<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You have total 10 options which you can use from this menu. Here I am explaining each of them for your better understanding.<\/p>\n<h3><span style=\"color: #0000ff;\">1. Move Here<\/span><\/h3>\n<p>As I already told you, you can move your data from one section to another section with this option.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-move-here.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Power of Right Click In Excel\"  class=\"alignnone size-full wp-image-5625\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-move-here.png\" alt=\"The Power of Right Click In Excel\" width=\"204\" height=\"31\" \/><\/a><\/p>\n<h3><span style=\"color: #0000ff;\">2. Copy Here<\/span><\/h3>\n<p>Just like moving data, you can also copy your data from one section to another section.<\/p>\n<p>After drag &amp; drop just click on &#8220;Copy Here&#8221; from the menu.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-copy-here.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Power of Right Click In Excel\"  class=\"alignnone size-full wp-image-5622\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-copy-here.png\" alt=\"The Power of Right Click In Excel\" width=\"198\" height=\"30\" \/><\/a><\/p>\n<h3><span style=\"color: #0000ff;\">3. Copy Here as Value<\/span><\/h3>\n<p>This is one my favorite things about this menu. You can use this option to paste your data as values.<\/p>\n<p>But here is the twist, Let&#8217;s say you have formulae in your worksheet and you want to convert that formulae into values.<\/p>\n<p>I bet this is a better option than paste special.<\/p>\n<p>It goes like this.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-paste-as-values.gif\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5626\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-paste-as-values.gif\" alt=\"excel-drag-drop-menu-paste-as-values\" width=\"464\" height=\"380\" title=\"\"><\/a><\/p>\n<ol>\n<li>Select the data from your worksheet.<\/li>\n<li>Now, by using right click drag &amp; drop it to the same place where it is.<\/li>\n<li>And, from the menu select &#8220;Copy Here as Value&#8221;.<\/li>\n<\/ol>\n<h3><\/h3>\n<h3><span style=\"color: #0000ff;\">4. Copy Here as Format<\/span><\/h3>\n<p>Yes, you get it right. You can use this option to paste <a href=\"http:\/\/excelchamps.com\/blog\/2016\/02\/how-to-use-format-painter-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">formatting from one section to another<\/a>.<\/p>\n<p>Just drag &amp; drop your data &amp; select the &#8220;Copy Here as Format&#8221;.<\/p>\n<p>It will just paste the formatting you have in your original section.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-copy-here-as-format.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Power of Right Click In Excel\"  class=\"alignnone size-full wp-image-5623\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-copy-here-as-format.png\" alt=\"The Power of Right Click In Excel\" width=\"200\" height=\"29\" \/><\/a><\/p>\n<h3><span style=\"color: #0000ff;\">5. Link Here<\/span><\/h3>\n<p>By using this option you can paste your values as a link (not as a hyperlink).<\/p>\n<p>Let&#8217;s say you have data in range D5:D10 &amp; when you drag that data on range F5:F10 using this drag drop menu, it will create a link in cells in range F5:F10.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-link-here.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Power of Right Click In Excel\"  class=\"alignnone size-full wp-image-5624\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-link-here.png\" alt=\"The Power of Right Click In Excel\" width=\"195\" height=\"28\" \/><\/a><\/p>\n<h3><span style=\"color: #0000ff;\">6. Create Hyperlink Here<\/span><\/h3>\n<p>You can also create a hyperlink in your worksheet using this drag &amp; drop menu.<\/p>\n<p>When you drag your data just select &#8220;Create Hyperlink Here&#8221;. And, it will create a hyperlink to your original cells.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-paste-hyperlink.gif\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5627\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-paste-hyperlink.gif\" alt=\"excel-drag-drop-menu-paste-hyperlink\" width=\"464\" height=\"380\" title=\"\"><\/a><\/p>\n<p>Things to Remember.<\/p>\n<ol>\n<li>When you have more than one cell in your original section it will create a hyperlink only for the first cell from the range.<\/li>\n<li>You are only able to use this option if your workbook is saved.<\/li>\n<\/ol>\n<h3><\/h3>\n<h3><span style=\"color: #0000ff;\">7. Shift Down and Copy<\/span><\/h3>\n<p>If you already have some data where you try to paste your original data, you can use this option.<\/p>\n<p>It will shift the data down &amp; copy your original data on that place.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-shift-down-and-copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Power of Right Click In Excel\"  class=\"alignnone size-full wp-image-5628\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-shift-down-and-copy.png\" alt=\"The Power of Right Click In Excel\" width=\"201\" height=\"30\" \/><\/a><\/p>\n<h3><span style=\"color: #0000ff;\">8. Shift Right and Copy<\/span><\/h3>\n<p>And if you want to move that data which you already have, in right direction use this option.<\/p>\n<p>This option will move it to the right &amp; copy your data to that place.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-shift-right-and-copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Power of Right Click In Excel\"  class=\"alignnone size-full wp-image-5630\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-shift-right-and-copy.png\" alt=\"The Power of Right Click In Excel\" width=\"200\" height=\"27\" \/><\/a><\/p>\n<h3><span style=\"color: #0000ff;\">9. Shift Down and Move<\/span><\/h3>\n<p>Use this option if you just want to move your original data and want to shift the data from destination section in a downward direction.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-shift-down-and-move.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Power of Right Click In Excel\"  class=\"alignnone size-full wp-image-5629\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-shift-down-and-move.png\" alt=\"The Power of Right Click In Excel\" width=\"201\" height=\"25\" \/><\/a><\/p>\n<h3><span style=\"color: #0000ff;\">10. Shift Right and Move<\/span><\/h3>\n<p>And, if you want to move data from destination cells in the right direction, drag &amp; drop your original data &amp; select &#8220;Shift Right and Move&#8221; from the menu.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-shift-right-and-move.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Power of Right Click In Excel\"  class=\"alignnone size-full wp-image-5631\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/12\/excel-drag-drop-menu-shift-right-and-move.png\" alt=\"The Power of Right Click In Excel\" width=\"202\" height=\"28\" \/><\/a><\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Over_To_You\"><\/span><span style=\"color: #ff0000;\">Over To You<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This menu is a super time saver. I hope it will save your lot of time &amp; efforts while working in excel.<\/p>\n<p>If you want to be more productive in excel, here I have a <a href=\"http:\/\/excelchamps.com\/excel-productivity-guide\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Excel Productivity Guide<\/a> for you.<\/p>\n<p>Make sure to share your view with me in the comment box. I would love to hear from you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a guest post by Puneet Gogia from ExcelChamps. Have you ever heard about Excel&#8217;s drag &amp; drop menu? If you haven&#8217;t, then it&#8217;s alright because this is one of the most unused options in excel that I ever found. This option is super helpful for those who are more dependent on their mouse. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":5645,"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":[7,10],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5619"}],"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=5619"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5619\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/5645"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=5619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=5619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=5619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}