Change Columns To Rows In Excel How To Drag Columns

You will see how to drag columns with a mouse and how to move a few non-contiguous columns at a time.

The latter is often considered unfeasible, but in fact theres a tool that allows moving non-adjacent columns in Excel 2016, 2013 and 2010 in a click.

For example, you might need to swap a couple of columns to view their data side-by-side.

Of course, you can try to hide the neighboring columns for a while, however this is not always the best approach because you may need to see data in those columns as well.

If you try to simply drag a column name, which appears to be the most obvious way to move columns, you might be confused to find that it does not work.

In fact, its one of those cases that can be classified as easier said than done.

But maybe its just my lack of sleight of hand ability:) Nevertheless, with some practice, I was able to get it to work, so you will definitely manage it too.

Change Columns To Rows In Excel License Type And

What I want is to switch the License type and Product ID columns so that a product ID comes right after the product name.

Youd better not do this anywhere around the column heading because the cursor can have too many different shapes in that area.

But it works just fine on the right or left edge of the selected column, as shown in the screenshot.

You will see a faint I bar along the entire length of the column and a box indicating where the new column will be moved.

To select several columns, click the heading of the first column you need to move, press and hold Shift, and then click the heading of the last column.

Then follow steps 2 - 4 above to move the columns, as shown in the screenshot.

It might require some practice, but once mastered it could be a real time saver.

Though, I guess the Microsoft Excel team will hardly ever win an award for the most user friendly interface on this feature:).

Please keep in mind that therere a few tricks here depending on whether you want to move a single column or several columns at a time.

You can actually skip step 1 and simply right click the columns heading to choose Cut.

If you try to do this, you will end up with the following error: The command you chose cannot be performed with multiple selections.

This will select only cells with data rather than entire columns, as shown in the screenshot below.

The operation is attempting to shift cells in a table of your worksheet.

Regrettably, it does not work for non-contingent columns either.

This is in theory.

In practice, most likely you would end up spending more time on specifying which exactly columns to swap and defining their new placements than dragging the columns manually.

Besides, there is no guarantee that the macro will always work as expected and each time you would need to verify the result anyways.

Change Columns To Rows In Excel For Mac