How to move rows and columns in Excel

When you edit documents on Excel columns and rows it may be during that process that you want to rearrange the order and position of the columns and rows. If you do not know how, you can follow the following method of TipsMake.com .

How to move rows and columns in Excel Picture 1

1. How to move columns in Excel

There are two ways to move columns in Excel, with the first one you can use the mouse to move, this method is suitable when the distance you want to move is not too far. The second way you need to use in combination with the keyboard.

1.1 Method 1

First, you need to highlight the column to be moved by hovering over the position at the top of the column then click on the column name, so the entire column will be highlighted.

How to move rows and columns in Excel Picture 2

Then move the mouse to the side of the highlighted column. You need to put the mouse in the position where the mouse will turn into a four-arrows cross.

How to move rows and columns in Excel Picture 3

Click and hold the mouse to the position where you want to move the column.

The blue border shows the position of the data column to be moved. Release the mouse when the appropriate location is reached.

How to move rows and columns in Excel Picture 4

When you move the data to a new location, the position in the old column will leave a space. Now you just need to clear that space. To delete that column space, you just need to black out the whole column by the method guided above.

Then right-click on the highlighted array and select Delete from the menu that appears.

How to move rows and columns in Excel Picture 5

1.2 Method 2

The second way we can use Excel's Cut and Paste function to be able to move columns of data.

First you need to black out the data column you want to move, doing this similar to the instructions mentioned above.

Next, right-click on the highlighted array, select Cut in the options panel that appears. Or you can also use the key combination Ctrl + X to perform the same function.

How to move rows and columns in Excel Picture 6

Next, you highlight the column at the position you want to transfer data to. (Note that if the blacked location you want to move to already has data there, the new column will move to the left of the old data position.)

Right-click on the highlighted array and then select the Insert Cut Cells row in the options panel that appears.

How to move rows and columns in Excel Picture 7

As you will see, the resulting column will be moved to the location you selected.

How to move rows and columns in Excel Picture 8

2. How to move rows in Excel

The method of moving rows in Excel is exactly the same as moving columns in Excel. So we also have two ways to move goods.

2.1 Method 1

You highlight the rows to move in Excel by moving to the numbered position on the left edge of the Excel interface. Click on that number.

How to move rows and columns in Excel Picture 9

Move the mouse to the upper or lower edge of the highlighted row. Then the mouse pointer will change to form a cross arrow.

How to move rows and columns in Excel Picture 10

You click and drag it to the position you want to move to. The blue box will display the position of the row you just blacked.

How to move rows and columns in Excel Picture 11

As you move the column leaving an empty row out, you need to highlight the row and right-click on the highlighted array and select Delete to delete the extra blank row.

How to move rows and columns in Excel Picture 12

2.2 Method 2

With the second method you also need to black out the entire row to be moved. Then right-click on the highlighted array and select Cut in the menu that appears. Or you can use the key combination Ctrl + X for the same function.

How to move rows and columns in Excel Picture 13

Then, like the column insertion method, you highlight the rows where you want the data to be transferred. (Note that if the blacked location you want to move to already has data there, the new row will be located above the old data position.)

Right-click on the highlighted array and then select the Insert Cut Cells row in the options panel that appears.

How to move rows and columns in Excel Picture 14

The highlighted product will be delivered to the location you selected.

How to move rows and columns in Excel Picture 15

Thanks to everyone for following our article TipsMake.com about moving rows and moving columns in Excel. Hopefully the article has provided sufficient information necessary for you to successfully implement this trick.

4 ★ | 2 Vote

May be interested

  • How to fix columns in ExcelHow to fix columns in Excel
    how to fix columns in excel. for excel spreadsheets that have a large number of columns, you want to freeze the first columns so that when you move the mouse over the column larger than the number of columns displayed in excel, these columns remain the same.
  • Instructions for coloring alternating rows and columns in ExcelInstructions for coloring alternating rows and columns in Excel
    alternating colors in excel is a useful technique to make your spreadsheet more visual. learn how to use conditional formatting in excel 2007 to 2016 to easily distinguish rows and columns.
  • How to convert rows into columns and vice versa in ExcelHow to convert rows into columns and vice versa in Excel
    the following article contains detailed instructions how to convert rows into columns and vice versa in excel. assuming i have the following data table, the attributes that are in the row i want to turn into columns.
  • How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016
    how to add columns, delete columns, add rows, delete rows in word 2007, 2010, 2013, 2016. the following article helps you perform the operation of inserting columns, rows or simply deleting redundant columns and rows in data tables in extremely simple ways.
  • Excel does not allow inserting additional columns and rows [FIXED]Excel does not allow inserting additional columns and rows [FIXED]
    excel does not allow inserting additional columns or rows, so you cannot continue editing the document? tipsmake has found the cause and how to fix it
  • Excel - Convert columns to rows in ExcelExcel - Convert columns to rows in Excel
    if you have an excel file and enter data in the wrong row or column or vice versa, what will you do? would you delete it and re-enter it? that takes up a lot of your time. let's see how taimienphi.vn guides you on how to convert columns into rows in excel.
  • Change the width of columns and the height of rows in ExcelChange the width of columns and the height of rows in Excel
    the default column widths and row heights in excel may not match the data you enter. you want to change the width, height of rows and columns so that data is displayed fully on cells in excel.
  • Hide and display columns and rows in ExcelHide and display columns and rows in Excel
    in the process of working with excel, you want to hide a certain row or column because of job requirements. the following article details how to display or hide columns and rows in excel.
  • Instructions on how to color alternating rows and columns in ExcelInstructions on how to color alternating rows and columns in Excel
    the following article details how to color alternating rows and columns in excel. colored alternating rows. highlight alternating columns. colored alternating rows of columns provided there is data and no data.
  • How to Hide Rows in ExcelHow to Hide Rows in Excel
    hiding rows and columns you don't need can make your excel spreadsheet much easier to read, especially if it's large. hidden rows don't clutter up your sheet, but still affect formulas. you can easily hide and unhide rows in any version of...