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