How to Move Cells with Keyboard in Excel (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working on Microsoft Excel Sometimes we need to move cells quickly for the ease of working. You can move cells in excel very smoothly with the keyboard. In this article, I am going to share with you 3 easy methods to move cells with the keyboard. You don’t have to use the mouse either.

Table of Contents hide

Download Practice Workbook

3 Suitable Methods to Move Cells with Keyboard in Excel

1. Perform Copy-Paste Method to Move Cells in Excel

2. Insert New Row or Column to Move Cells with Keyboard

3. Delete Column or Row to Move Cells with Keyboard

Things to Remember

Conclusion

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Move Cells with Keyboard.xlsx

3 Suitable Methods to Move Cells with Keyboard in Excel

Suppose we have a dataset of some students’ Names, Departments, Id No., and Grade. In this article, we will move cells in this dataset using keyboard buttons and shortcuts.

1. Perform Copy-Paste Method to Move Cells in Excel

If you want to move your cell into a new location you can apply the copy paste method in excel.

Steps:

Select a row. Here I have selected cell (B13) to (E13).
Press Ctrl+C to copy.

Select a new cell where you want to paste.
Type Ctrl+V.

You will see we have successfully moved the cell by applying copy-paste.

Similar Readings

2. Insert New Row or Column to Move Cells with Keyboard

By combining Ctrl and Shift keys you can insert new rows or columns in excel. Follow the following steps below-

Steps:

Firstly select a row. Here I have selected row (11).
Now holding the Shift key press the down arrow(↓) twice to select the 12th and 13th rows from the dataset.

While the rows are selected press: Ctrl+Shift+Plus sign(+) to insert new rows.

Thus you can move cells by inserting new rows with the keyboard in excel.

3. Delete Column or Row to Move Cells with Keyboard

By deleting columns or rows with the keyboard you can also move cells with the keyboard in excel. Follow the steps below-

Steps:

Choose a row from the dataset. Here I have chosen the 13th
Press Ctrl+Minus sign(-) from the keyboard to remove the row.

As you can see the row has been removed. Thus by deleting rows you can move cells with the keyboard in excel.

Things to Remember

When shifting between cells don’t forget to turn the Scroll key.
You can check in the status bar whether the Scroll Lock is on or off.

Conclusion

In this article, I have covered about 3 methods to moving cells with the help of a keyboard in excel. I hope you have a clear view of moving cells with the help of a keyboard. If you find any problems regarding this don’t forget to let us know in the comment section below. Thanks!