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
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.
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.
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.
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
Bored of downloading text heavy / copy-pasted eBooks?
If Yes, you will enjoy this guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.