How To Move Rows In Excel Mac

Sentry Video – The best style to Motility Rows / Columns in Excel

Sometimes when working with information in Excel, yous may have a need to move rows and columns in the dataset.

For example, in the below dataset, I want to rapidly move the highlighted row to the peak.

At present, are you thinking of copying this row, inserting the copied row where you want it, and then deleting it?

If aye – well that's one way to do this.

Simply there is a lot faster way to move rows and columns in Excel.

In this tutorial, I will prove yous a fast fashion to move rows and columns in Excel – using an amazing shortcut.

Move Rows in Excel

Suppose I accept the following dataset and I want to move the highlighted row to the second row (just below the headers):

Hither are the steps to do this:

Select the row that you want to movement.
Hold the Shift Cardinal from your keyboard.
Motility your cursor to the edge of the selection. It would display the movement icon (a four directional arrow icon).
Click on the edge (with left mouse push) while nevertheless belongings the shift key.
Move it to the row where you lot want this row to be shifted
Leave the mouse button when you see a bold line right beneath the row where yous want to move this row.
Go out the Shift-cardinal (think to keep the Shift key pressed till the end)

Below is a video that shows how to move a row using this method.

Note that in this example, I have moved the selected cells only.

If you want to move the unabridged row, you can select the entire row and so follow the aforementioned steps.

Here are some important things to know about this method:

You can move contiguous rows (or some cells from the contiguous rows). You can't move not-contiguous rows using this method. For instance, you can't motility row # four and 6 at the same fourth dimension. However, you can move row #five and 6 at the same time by selecting it.
When you move some cells in a row/column using this method, information technology will not impact any other data in the worksheet. In the higher up example, whatsoever data exterior (in a higher place/below or to the correct/left of this tabular array) remains unaffected.

The aforementioned technique can also be used to move columns in Excel.

Here are the steps:

Select the column (or contiguous columns) that y'all want to movement.
Concur the Shift Key from your keyboard.
Move your cursor to the border of the selection. It would display the move icon (a four directional arrow icon).
Click on the edge (with left mouse push) while still holding the shift key.
Motion information technology to the column where y'all desire this row to be shifted
Leave the mouse button when you run into a bold line to the edge of the column where you lot want to move this column.
Go out the Shift-key (think to go along the Shift central pressed till the end).

You lot May Also Like the Following Excel Tutorials: