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.
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.
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.
- 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.
- 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
- How to Display the Cell Formulas in Excel (6 Methods)
- Check If Multiple Cells Are Equal in Excel (4 Methods)
- How to Lock Cells in Excel Formula (2 Easy Ways)
- Lock Certain Cells in Excel (4 Methods)
- How to Group Cells with Same Value in Excel (3 Methods)
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.
- 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.
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.
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
- How to Click One Cell and Highlight Another in Excel (2 Methods)
- How to Lock Cells in Excel When Scrolling (2 Easy Ways)
- [Fix]: Arrow Keys Not Moving Cells in Excel (2 Methods)
- How to Select Cells in Excel Using Keyboard (9 Ways)
- Select Cells with Certain Value in Excel (5 Methods)
- How to Shift Cells Down in Excel without Changing Formula (4 Methods)