Pinterest Pixel

The Power of Right Click In Excel

This is a guest post by Puneet Gogia from ExcelChamps. Have you ever heard about Excel’s drag... read more

Bryan
Posted on

Steps To Follow

Overview

The Power of Right Click In Excel | MyExcelOnline The Power of Right Click In Excel | MyExcelOnline

This is a guest post by Puneet Gogia from ExcelChamps.

Have you ever heard about Excel’s drag & drop menu?

If you haven’t, then it’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.

So, today I’ll show you how to use this hidden power tool.

The Power of Right Click In Excel

Steps To Use Drag Drop Menu

Using this drag drop menu is super easy. You just need few clicks.

Let’s say you want to move your data from one section to another section. All you have to do.

1. Select your data.

2. Go to the edge of your selection (Thick Border).

3. Right click & hold.

4. Now by holding your mouse, drag & drop it to the place where you want to move it.

5. And, when you drop it, you’ll get a menu. Select “Move Here” from the menu.

move-data-with-excel-drag-drop-menu

Other Options You Have

You have total 10 options which you can use from this menu. Here I am explaining each of them for your better understanding.

1. Move Here

As I already told you, you can move your data from one section to another section with this option.

The Power of Right Click In Excel

2. Copy Here

Just like moving data, you can also copy your data from one section to another section.

After drag & drop just click on “Copy Here” from the menu.

The Power of Right Click In Excel

3. Copy Here as Value

This is one my favorite things about this menu. You can use this option to paste your data as values.

But here is the twist, Let’s say you have formulae in your worksheet and you want to convert that formulae into values.

I bet this is a better option than paste special.

It goes like this.

excel-drag-drop-menu-paste-as-values

  1. Select the data from your worksheet.
  2. Now, by using right click drag & drop it to the same place where it is.
  3. And, from the menu select “Copy Here as Value”.

4. Copy Here as Format

Yes, you get it right. You can use this option to paste formatting from one section to another.

Just drag & drop your data & select the “Copy Here as Format”.

It will just paste the formatting you have in your original section.

The Power of Right Click In Excel

5. Link Here

By using this option you can paste your values as a link (not as a hyperlink).

Let’s say you have data in range D5:D10 & 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.

The Power of Right Click In Excel

6. Create Hyperlink Here

You can also create a hyperlink in your worksheet using this drag & drop menu.

When you drag your data just select “Create Hyperlink Here”. And, it will create a hyperlink to your original cells.

excel-drag-drop-menu-paste-hyperlink

Things to Remember.

  1. When you have more than one cell in your original section it will create a hyperlink only for the first cell from the range.
  2. You are only able to use this option if your workbook is saved.

7. Shift Down and Copy

If you already have some data where you try to paste your original data, you can use this option.

It will shift the data down & copy your original data on that place.

The Power of Right Click In Excel

8. Shift Right and Copy

And if you want to move that data which you already have, in right direction use this option.

This option will move it to the right & copy your data to that place.

The Power of Right Click In Excel

9. Shift Down and Move

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.

The Power of Right Click In Excel

10. Shift Right and Move

And, if you want to move data from destination cells in the right direction, drag & drop your original data & select “Shift Right and Move” from the menu.

The Power of Right Click In Excel

Over To You

This menu is a super time saver. I hope it will save your lot of time & efforts while working in excel.

If you want to be more productive in excel, here I have a Excel Productivity Guide for you.

Make sure to share your view with me in the comment box. I would love to hear from you.

If you like this Excel tip, please share it
The Power of Right Click In Excel | MyExcelOnline The Power of Right Click In Excel | MyExcelOnline
The Power of Right Click In Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Top 10 Excel Double Click Mouse Tricks

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...