Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

Working on your Excel spreadsheets can be much faster than you think if you use this 5 Simple drag and drop MS Excel Shortcuts:

1. MS Excel Shortcut for Copying and Moving:

Excel has a unique feature hidden somewhere in the “Paste Special” column which many people don’t know about. Values can be added, subtracted, divided and multiplied while moving the values from one cell to another.
For example, Row 1 of your excel sheet contains value 10. Row 2 contains values 20.

You can change the value of Row 2 to the sum of both these values using the following steps:

Step 1: Copy the value in Row 1 to your clipboard.
Step 2: select the cell containing value in Row 2
Step 3: Press Alt+E+S+D
Step 4: Press Enter or select Okay in the dialogue box.


Output-of-Dataset-MS-Excel-Shortcuts The same function can be used for Subtraction by pressing Alt+E+S+S in Step 3. For multiplication, Alt+E+S+M and for a division, Alt+E+S+I.

Further reading: Learn more about Go To Special Made easy in MS Excel [Infograph]

2. MS Excel Shortcut for Copying and Moving Worksheets:

Copying a worksheet can be tricky in Excel, but it can be made easier with a simple use of your mouse and the Ctrl key.

Use the following steps to copy or move worksheets:

Step 1: Locate the Sheet tab on the lower left corner of the window. Suppose the Sheet that needs to be copied is named S1.
Step 2: Click on the S1 tab, and hold. A small icon of a sheet will appear near the pointer.
Step 3: Press the Ctrl key without leaving the mouse. A plus sign will appear on the sheet.
Step 4: A black pointer appears between the sheets as you move the sheet icon through the tab. Drop the icon on the desired location.Copying-Moving-Worksheets-MS-Excel-ShortcutsIn order to move your sheet to a different location on the tab, follow the same steps as given above, except Step 3, which needs to be skipped.

Further reading: Learn Advanced Excel Training program and become a Ninja

3. MS Excel Shortcut for Dragging and Inserting:

Copying and inserting a row between two existing rows on a spreadsheet can also be done in a jiffy using MS excel shortcuts.

Use the following steps to drag and insert:

Step 1: Suppose you want to copy the values of Column ‘A’ to Column ‘B’. Select Column A by going on the column tab of the spreadsheet and clicking on the title ‘A’ when a black arrow appears.
Step 2: Take your pointer to the right-hand side border of the selected column, which would change the pointer to a dragger.
Step 3: Hold the mouse and simultaneously hold the Ctrl Key.
Step 4: Drag the pointer over column B and drop it.

Follow same steps to delete the values from Column A and pasting those in saying Column C with the exception of Step 3. In this step, instead of holding the Ctrl key, you should hold the Shift key.

Further Reading: Learn more about Tricks of Text to Columns in MS Excel

4. MS Excel Shortcut for Right Click Excel functions:

Excel has an amazing secret copy menu, which allows you to choose from many copies and move options for the selected values.

To open this menu, follow these steps:

Step 1: Select the desired cell. Move to the border of this cell while selected, till the pointer turns into a dragger.
Step 2: Right-click and drag the mouse to the desired location. Then release the mouse.MS-Excel-Shortcut-for-Right-click-function

5. MS Excel Shortcut for Converting values to percentage and currency:

Calculating the percentage might be easier in Excel than in other programs, yet takes more time than it should.

Here is ms excel shortcut to this function and as explained below:

Step 1: type in the decimal value in a cell and select the cell.
Step 2: Press Ctrl+Shift+4

Press Ctrl+Shift+5 in Step 2 to converting a value into currency.

So the next time you use MS excel shortcuts, use these drag and drop excel tips and tricks and see the difference yourself!

KickStart your Excel learning with our Free Online Excel course 

Do share it with your friends and colleagues.

Pre-Registration Open

Power BI Dax

Related Tutorials

Text To Column in Excel | Split Cells
January 4, 2019
Pivot Tables (Complete Guidelines)
December 27, 2018
Power Bi Dax Deduplication Based On Column
December 17, 2018
Special Character Symbol List with Shortcodes in Excel
December 15, 2018
December 10, 2018
December 10, 2018
How to use ABS Function in Excel
December 10, 2018
How to use AND Function in Excel
December 10, 2018
Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018