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

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

Download Workbook


3 Methods to Move Cells without Replacing in Excel

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.

How to Move Cells in Excel without Replacing


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.

How to Move Cells in Excel without Replacing

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

How to Move Cells in Excel without Replacing

Read More: How to Move Highlighted Cells in Excel (5 Ways)


Similar Readings


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.

A context menu will appear.

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

How to Move Cells in Excel without Replacing

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

How to Move Cells in Excel without Replacing

Read More: How to Shift Cells Right in Excel (4 Quick Ways)


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.

How to Move Cells in Excel without Replacing

Read More: How to Shift Cells Up in Excel (5 Quick Ways)


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.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions.


Related Articles

Afia
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo