There are several ways to move cells in Excel without replacing. Among them, we will show you 3 simple, easy, and effective methods.
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.
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.
- How to Shift Rows Down in Excel (3 Simple & Easy Ways)
- Move One Cell to Right Using VBA in Excel (3 Examples)
- How to Move Rows Up in Excel (2 Quick Methods)
- Move Rows in Excel (4 Simple & Quick Methods)
- How to Shift Data Up in Excel (3 Easiest Ways)
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.
➤ 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.
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.
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.