+4 votes
8 views
in Sell ​​on the Internet by (74k points)
reopened
Move columns and rows in Excel: step by step instructions

1 Answer

+5 votes
by (490k points)
edited
 
Best answer

image

Move columns and rows in Excel: step by step instructions

To sort a table in Excel or align the columns and rows, you often need to move those columns and rows. In this guide we show you the best way to do it. We present two options with which you can move columns and rows in Excel effortlessly and without formula or format errors in the corresponding cells..

Index
  1. How to move an Excel column with drag and drop?
    1. Step 1: select column
    2. Step 2: move the cursor to the edge of the column
    3. Step 3: move the column with drag and drop
    4. Step 4: drop the column
  2. Quick guide: how to move a column in Excel using drag and drop
  3. Crop a column in Excel and paste it elsewhere
  4. How to move rows in Excel with drag and drop?
    1. Step 1: select row
    2. Step 2: move the cursor to the edge of the row
    3. Step 3: move an Excel row with drag and drop
    4. Step 4: drop the row
  5. Quick guide: how to move a row in Excel using drag and drop
  6. Crop a row in Excel and paste it elsewhere

How to move an Excel column with drag and drop?

Moving one or more columns in Excel does not require the effort required by the copy and paste function . Since this function, which is normally very practical, carries a great risk of the column formulas being formatted. Also, it is a time-consuming method.

One of the most reliable and simple alternatives is drag and drop . Only condition: you must not have related cells that are outside the selected area..

Step 1: select column

First of all, select the column or columns you want to move. To do this, left click on the column header to select the entire column. You can also click on any cell in the desired column and select the entire column with the key combination [Ctrl] + [Space].

image
Once selected, the column is marked with another color in Excel.

Step 2: move the cursor to the edge of the column

In the next step, move the mouse to the left or right side edge of the selected column, until the mouse cursor turns into an arrow cross or a hand symbol (depending on the version of Excel you use) .

image
Select the entire column, for example, using the keyboard shortcut or clicking the mouse.

Step 3: move the column with drag and drop

Now, hold down the [Shift] key together with the left mouse button and drag the selected column (s) to the desired place using drag and drop . The new duty station is marked in color or by a dashed line..

image
Drag the column to the desired position.

Step 4: drop the column

When you've reached the right place, release the mouse key and hold the [Shift] key. The Excel column will move to the desired position. If there is already a column with content at that point, this column automatically scrolls to the right or left.

image
The column has been successfully scrolled and is now between the other two columns in the Excel sample document.

Quick guide: how to move a column in Excel using drag and drop

  1. Mark the column you want to move by left-clicking on the column header .
  2. Move the cursor to the edge of the column , until it turns into a cross of arrows or a hand .
  3. Hold down [Shift] and the left mouse button and drag the column to the desired position.
  4. Release the key and button and the column will jump to the desired location.

Crop a column in Excel and paste it elsewhere

As an alternative to the copy and paste option , you can make use of the cut and paste option . The usual key combination is [Ctrl] + [X] to cut and [Ctrl] + [+] to paste. Before you just have to select the desired column, either by clicking on the column header or using [Ctrl] + [Space]. Then select the desired target position and paste the column with [Ctrl] + [+] .

Note

The more common Ctrl + V key combination also works for pasting trimmed columns, but this can cause changes to the column or row format. Therefore, the plus symbol key is a safer option in this case.

How to move rows in Excel with drag and drop?

Excel's procedure for moving columns can also be applied to moving rows.

Step 1: select row

Select the row or row area you want to move. In this context, you can left-click on the row margin numbering (row header ) to select the entire row. You can also click on any cell in the desired row and select the entire row with the key combination [Ctrl] + [Shift] .

image
Use your preferred mode to select the Excel row you want to scroll.

Step 2: move the cursor to the edge of the row

Now, move the mouse to the top or bottom edge of the selected row, until the cursor turns into a cross of arrows or a hand .

image
The entire row has been selected for scrolling.

Step 3: move an Excel row with drag and drop

Hold down the [Shift] key together with the left mouse button and drag the row to the desired location using drag and drop .

image
Drag the Excel row you want to move to the desired position.

Step 4: drop the row

Release the mouse button and the [Shift] key: now the row is in the desired place.

image
Excel row successfully scrolled.

Quick guide: how to move a row in Excel using drag and drop

  1. Mark the row you want to scroll by left-clicking on the row header .
  2. Move the mouse to the top or bottom edge of the row until the cursor changes to an arrow cross or hand .
  3. With the [Shift] key held down and the left mouse button pressed , drag the row up or down to the desired position.
  4. Release the [Shift] key and the mouse button and the row will appear in the desired location.

Crop a row in Excel and paste it elsewhere

With rows you can also use the cut and paste function . Once you have selected the row by clicking on the header or [Ctrl] + [Shift] , hit the key combination [Ctrl] + [X] to cut. Then select the desired position and paste the row with [Ctrl] + [+] .

advice

You can find more practical tips for Excel in the following articles:

- Create drop down menus in Excel

- Useful shortcuts in Excel

- Transpose in Excel

- Create tables in Excel

- Delete empty rows in Excel


...