How to Move Up and Down in Excel (5 Easy Ways)

To shift a row upwards using the Shift key and mouse, we first choose a row and then place it in the upper position. You will notice that the selected row has moved up to the top, while the other cells have moved down by just one cell.

Move Up or Down a row in Excel


Method 1 – Using the Shift Key and Mouse 

We will first move the last row to the top.

  • Select the row that you want to move in your Excel worksheet.Use Shift Key and Mouse to Move Up and Down
  • Bring the mouse cursor to the top edge. You will get the Move Icon, which looks like a four-directional arrow icon.Use Shift Key and Mouse to Move Up and Down
  • Hold the Shift key and drag it up to the top until you see an icon like this in the figure below.Use Shift Key and Mouse to Move Up and Down
  • Drop the selected row. The selected row has come to the top, and the other cells have dropped a row below.Use Shift Key and Mouse to Move Up and Down

Note: This method is also applicable for multiple cells or rows at once, but they have to be adjacent to each other.


Method 1 – Using the Insert Copied Cells Command 

We want to move the cell D10 to D6 in the previous example.

  • Select the D10 cell.
  • Go to the Home tab and select Copy or press Ctrl + C.Utilize Insert Copied Cells Command to Move Up and Down
  • Select the cell that you want to move.
  • Right-click and select Insert Copied Cells.Utilize Insert Copied Cells Command to Move Up and Down

You will see another window.

  • Select Shift cells down and press OK.Use Copy and Insert Copied Cells
  • Cell D6 has been replaced with D10. The cells below D6 have been downed by one. The value in D13 has come to cell D14. As we don’t need the value in D14, we can delete it.

Utilize Insert Copied Cells Command to Move Up and Down

Here’s the final result in the following image.

Utilize Copy and Insert Copied Cells Command

Note: You can also use this method to move multiple adjacent cells simultaneously.


Method 3 – Using the Insert Cut Cells Command 

  • Select the D10 cell, go to the Home tab, and select Cut or press Ctrl + X.Utilize Insert Cut Cells Command to Move Up and Down
  • Select cell D6 and right-click, then select the Insert Cut Cells option.Utilize Cut and Insert Cut Cells Command

You will get the final result shown in the following image.

Utilize Insert Cut Cells Command to Move Up and Down


Method 4 – Delete Specific Cells to Move Up and Down in Excel

There are two blank cells. We’ll remove them by moving the other cells.

Delete Specific Cells to Move Up and Down in Excel

  • Select the blank cells C4 and C7 (For multiple selections, hold the Ctrl key and left click on the cells).
  • Right-click and select Delete.
  • Select Shift cells up and click OK.

You will see the result in the following mage.

Delete Specific Cells to Move Up and Down in Excel

Read More: Viewing Multiple Workbooks: Synchronous Scrolling in Excel


Method 5 – Using the Go to Special Feature

Here is an example of a list that contains some empty rows. We’ll delete the rows with blank cells and move the rest of them up.

  • Select the whole table.Use Goto Special Feature to Move Up and Down in Excel
  • Click the F5 button, and a window will appear.
  • Select Special. A new pop-up will appear:
  • In the Go To Special window, select Blanks and click OK.Use Goto Special Feature to Move Up and Down in Excel

All the empty cells in the selection are highlighted.Use Goto Special Feature

  • Right-click on the selection and select Delete.
  • Select Shift cells up and click OK.

You will see the result in the following image.

Use Goto Special Feature to Move Up and Down in Excel

Read More: How to Scroll One Row at a Time in Excel


Download the Practice Workbook


Frequently Asked Questions

Can I customize shortcuts for moving rows and cells in Excel?

Yes, you can customize Excel shortcuts according to your preferences. Navigate to the File tab > Options > Advanced > Lotus compatibility section. There, you can assign personalized keys for moving rows and cells to your specific needs.

Are there Excel shortcuts for moving entire columns efficiently?

To select and move entire columns quickly, click on the column letter, hold down the Shift key, and then click on another column letter. Alternatively, use the arrow keys while holding down the Shift key to extend your column selection.

Is there a way to navigate through Excel using a keyboard shortcut to switch between worksheets?

Use Ctrl + PgUp to move to the previous worksheet and Ctrl + PgDn to move to the next one.


Related Articles


<< Go Back to Scrolling in Excel | Navigation in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aniruddah Alam
Aniruddah Alam

Md. Aniruddah Alam, a graduate of Bangladesh University of Engineering & Technology, Dhaka, holds a BSc.Engg in Naval Architecture & Marine Engineering. Joining Softeko in August 2022 as an Excel and VBA content developer, he has authored 90+ articles, covering fundamental to advanced Excel topics. He actively develops VBA codes for Excel automation and offers solutions in the Exceldemy Forum. Beyond work, he finds leisure in reading books, and taking relaxing walks, showcasing well-rounded blend of professional and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo