# How to Move Cells without Replacing in Excel (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

There are several ways to move cells in Excel without replacing them. Among them, we will show you 3 simple, easy, and effective methods.

## How to Move Cells without Replacing in Excel: 3 Methods

Here, the following Teacherâ€™s Salary List table shows the Name, Department, and Salary columns. We will move cells of this table in Excel without replacing them. Here, we used office 365. You can use any available Excel version.

### Method-1: Using Shift Key to Move Cells without Replacing

Here, we want to move the brown-colored cells from rows 6 and 7, and we want to place them in rows 11 and 12. We will use the SHIFT key for this purpose.

âž¤ First of all, we will select rows 6 and 7.

âž¤ After that, we will hover the mouse cursor over the selected border.

We will see that a four-sided arrow appears.

âž¤ Next, we will press and hold the SHIFT key on the keyboard.

âž¤ After that, we will click and hold the left mouse button, and we will drag down the rows to the new position.

Here, the new position is at rows 11 and 12, and we can see a green border at rows 11 and 12.

Also, we can see the B11:D12 written sign which indicates that the rows from 6 and 7 will move to rows 11 and 12.

âž¤ Then, we will release the left mouse button.

âž¤ Afterward, we have to release the SHIFT key.

Finally, we can see that rows 6 and 7 are moved to rows 11 and 12.

Read More: How to Move Highlighted Cells in Excel

### Method-2: Using Insert Cut Cells Option

Here, we want to move the cells of the Salary column to the position of the Department column. We will use the Insert Cut Cells option for this case.

âž¤ First of all, we will select the entire Salary column, and we will right-click on the mouse.

âž¤ Then, we will select the Cut option.

Now, we have to select the column where we want to replace the Salary column.

âž¤ Here, we selected the Department column as we want to replace the Salary column there.

âž¤ Then, we have to right-click on the mouse and select Insert Cut Cells from the context menu.

Finally, we can see the replacement of the Salary column.

Read More: How to Move a Group of Cells in Excel

### Method-3: Using Sort Option

In the following table, we want to move the cells of row 10 to the top position. Here, row 10 contains the highest salary, therefore, we will use the largest to smallest sort order to replace this row.

âž¤ To begin with, we have to select the entire dataset.

âž¤ After that, we will go to the Home tab > select Editing > select Sort & Filter > select Custom Sort.

A Sort window will appear.

âž¤ We will select Options.

After that, a Sort Options window will appear.

âž¤ Typically Sort top to bottom is selected as Orientation, keep that as is, and click OK.

âž¤ Now, we will select Sort by as Salary, Order as Largest to Smallest, and click OK.

Finally, we can see the sorted dataset from largest salary to smallest salary.

## Conclusion

Here, we tried to show you 3 methods to move cells in Excel without replacement. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions feel free to know us in the comment section.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF