How to Move Cells Up in Excel (3 Easy Ways)

Sometimes we face the necessity to move the cells up. Here, I will try to show how to Move cells Up in Excel to overcome our cells moving problem.

I am going to make it clear with a dataset containing the Football Player Ranking around the world. Here, the Player’s Name will be illustrated with their Ranking and Country column.

How to Move Cells Up in Excel


Download Practice Workbook


3 Ways to Move Cells Up in Excel

1. Drag and Drop Method to Move Cells Up in Excel

Drag and drop is a very easy and efficient way to Move Cells Up in Excel. There are two different ways according to the output in the drag and drop method.


1.1. Using SHIFT + Drag

Steps:

  • Select the cells that we want to move up. Here, I selected the cell range C9:D9 to move up C5:D5.

  • Hold the SHIFT key and drag the cursor to the desired position.

How to Move Cells Up in Excel

The selected cells will move to the desired places and the rest of the cells will go down according to their previous orientation.


1.2. Applying CTRL + Drag

Steps:

  • Select the cells that we want to move up. Here, I selected the cells C14:D14 to move up to C5:D5.

How to Move Cells Up in Excel

  • Hold the CTRL key and drag the cursor to the desired cell.

We will see the selected cells move to the destined location.

Note: In this way, the previous orientation will remain the same. Just the selected cells will move up and it will also be to their previous position.

Read More: How to Drag Cells in Excel Using Keyboard (5 Smooth Ways)


2. Cut & Paste Method to Move Cells Up in Excel

Cut and Paste is a very common and easy way to move cells up in Excel.

Steps:

  • Select all the cells that we want to move up. Here, I selected the cells B19:D21 to move up to B15:D17.

How to Move Cells Up in Excel

  • Then, use the Cut command. Here, I used the CTRL + X command. You can also use the Cut command from Context Menu or Home Tab from the ribbon.

  • Select the cells where you want to move the cells up.
  • Press CTRL + V for the Paste command.

Then, we will see the selected cells move up.

Note: In this case, the copied cells will fully shift to the new position.

Read More: How to Move All Cells Down in Excel (5 Methods)


Similar Readings


3. Copy & Paste Method to Move Cells Up in Excel

You can use the Copy and Paste method which is another excellent way to move cells up in Excel.

Steps:

  • Select all the cells that we want to move up. Here, I selected the cells B20:D22 to move up to B15:D17.

How to Move Cells Up in Excel

  • Give Copy command. Here,  I used the CTRL + C command. You can also use the Copy command from Context Menu or Home tab from the ribbon.

  • Select the cell where you want to move the cells up.
  • Press CTRL + V for the Paste command.

How to Move Cells Up in Excel

The selected cell will move up.

Note: In this case, the copied cells will remain the same and move up to the new position.

Read More: How to Move a Group of Cells in Excel (4 Easy Ways)


Practice Section

For more expertise, you can practice here.

How to Move Cells Up in Excel


Conclusion

In this article, I tried to show as simple as possible ways of how to move cells up in Excel. You can choose any way which fits you. For any type of query comment down below.


Related Articles

Tags:

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo