If you’re seeking to relocate a column or a row to a various place in your spread sheet, you have numerous choices to do that in Microsoft Excel. We’ll show you what those choices are.

To utilize any one of the below techniques, initially, open your spreadsheet with Microsoft Excel on your Windows or Mac computer.

How to Move a Column in Excel Move a Column With Drag and also Drop Move a Column With Cut and also PasteHow to Move a Row in Excel Move a Row With Drag and also Drop Move a Row With Cut as well as Paste

Exactly how to Move a Column in Excel

To move a column in an Excel spreadsheet, use either drag and drop or the cut and paste approach.

With Excel’s drag and decline method, you can move your columns about simply by dragging and dropping them.

To use this method, initially, find the column you wish to move in your spreadsheet. On top of this column, click the column letter so the whole column is selected.

Utilize your mouse or trackpad to bring the arrow to the boundary of the column. This transforms your cursor into a four-arrow symbol.

While your arrow is a four-arrow symbol, press as well as hold the Shift key on your keyboard. Then drag the column to its new place in your spread sheet. Excel will certainly put your column to the left of the column where you drop it.

And that’ it. Your selected column is now offered at its brand-new location.

An additional means to move a column in your spreadsheet is by reducing as well as pasting the column.

To utilize this approach, find the column you want to relocate your spread sheet. Right-click the letter at the top of this column and pick “Cut” from the menu.

You’ll see a computer animated populated line around your picked column. This confirms your column is successfully cut.

Locate the column where you want to position your selected column. Excel will certainly position your cut column to the left of this brand-new column. Right-click the letter of this new column and select “Insert Cut Cells” from the food selection.

Your initial column will certainly show up to the left of the selected column.

And that’s how you move around your columns in your Excel spread sheets!

If you have data in one column that you want to be divided right into several columns, dealing with that is very easy!

How to Move a Row in Excel

Like with columns, you have a number of ways to move rows in your spreadsheets. Usage either drag as well as decline or cut and paste to move around your selected rows.

To swiftly relocate a row to a brand-new location, utilize this drag and drop technique.

Initially, discover the row to move in your spread sheet. After that click that row’s number to the severe left of your spread sheet.

Float your arrow over the picked row’s boundaries, and your arrow will certainly turn into a four-arrow icon.

While your cursor is still a four-arrow symbol, press as well as hold the Shift trick on your key-board. After that drag the row to its brand-new area.

Your row is currently put at its new area.

If you do not choose drag as well as decrease, use the cut and paste approach to relocate your rows.

Initially, in your spread sheet, locate the row to relocate. After that right-click this row’s number as well as pick “Cut” from the food selection.

Currently find the row above which you want to put your cut row. Right-click this new row’s number and also choose “Insert Cut Cells” from the menu.

Your row is now at its brand-new area.

As well as you’re ready.

There are times when you wish to relocate your information around in your spreadsheets. With Excel’s fast and also very easy relocation choices, you can quickly reorganize data in your numerous spreadsheets. Extremely helpful!

And, if you ever require to transform a row right into a column, Excel makes it just as easy to do that.