Excel is a powerful tool that allows users to manipulate and organize data quickly and efficiently. One of the most common tasks users perform in Excel is dragging and inserting data. This can be done using a mouse, but there is a quicker and more efficient way to achieve this task using the Keyboard Shortcut to Drag and Insert In Excel.
Keyboard Shortcut to Drag and Insert In Excel
The keyboard shortcut for Drag and insert in Excel is Shift + drag for Windows and ⇧drag for Mac.
This shortcut allows users to easily insert copied data into a new location within the same worksheet or a different worksheet.
Here’s how to use this shortcut:
- Select the cells that contain the data you want to move.
- Hover your cursor over the border of the selected cells until it turns into a four-headed arrow.
- Hold down the Shift key for Windows or the ⇧ key for Mac.
- Click and drag the selected cells to the new location where you want to insert them.
- Release the mouse button and the Shift or ⇧ key.
- A small menu will appear with three options: “Copy Here”, “Move Here”, or “Cancel”. Choose the “Move Here” option to move the data to the new location.
Points to Remember:
- This keyboard shortcut can be used to insert data into a new location within the same worksheet or a different worksheet.
- This shortcut can be used to copy and move data.
- The “Move Here” option will remove the data from the original location and insert it into the new location.
- Users can also use the “Copy Here” option to insert a copy of the data into the new location without removing it from the original location.