ExcelTutorials

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

3 Mins read

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

PDF GUIDE BOOKS

  • Download Excel Shortcuts for Windows & Mac
  • Basic to Advanced Excel Formulas PDF Guide

This Book will help you to get Excel Skills & Boost your career.

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 the value in Row 2
  • Step 3: Press Alt+E+S+D
  • Step 4: Press Enter or select Okay in the dialogue box.
Copying-Moving-Dataset-MS-Excel-Shortcuts
Paste-Special-MS-Excel-Shortcuts
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.

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-Shortcuts

In 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.

15 Excel Data Cleaning Tricks Guidebook

Bored of downloading text heavy / copy-pasted eBooks? If Yes, you will enjoy this guidebook (43 pages) 

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 the 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.

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.

Bonus: Excel Cell Drag & Drop with Enabling Fill Handle

In this section, we discussed the process of enabling fill handling and Excel Cell drag and drop. This feature helps you to improve your speed in excel. Follow Below steps:

  • Step 1: Click Excel File
  • Step 2: Then click on Options
  • Step 3: Move to Advanced Tab
  • Step 4: Select and Check-Box Enable fill handle and cell drag-and-drop.
  • Step 5: Finally, click Ok for cell drag and drop.

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

Excel Vlookup formula – Guidebook

Excel Vlookup Formula

Bored of downloading text heavy / copy-pasted eBooks?

If Yes, you will enjoy this guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…