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

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.


Download Practice Workbook

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


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.

How to Move Cells with Keyboard in Excel


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.

Perform Copy-Paste Method to Move Cells in Excel

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

Perform Copy-Paste Method to Move Cells in Excel

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

Read More: [Fixed!] Unable to Move Cells in Excel (5 Solutions)


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.

Insert New Row or Column

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

Insert New Rows or Columns

Read More: How to Shift Rows Down in Excel (3 Simple & Easy Ways)


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.

Delete Column or Row

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

Read More: How to Move Merged Cells in Excel (3 Suitable Ways)


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!


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo