Press and hold the Shift key, and then drag the column to a new location.But it works just fine on the right or left edge of the selected column, as shown in the screenshot. You'd better not do this anywhere around the column heading because the cursor can have too many different shapes in that area. Hover the mouse pointer over the edge of the selection until it changes from a regular cross to a four-sided arrow.What I want is to switch the " License type" and " Product ID" columns so that a product ID comes right after the product name. I will use the AbleBits price list for this example. Suppose, you have a worksheet with information about your company's products and you want to quickly swap a couple of columns there. But maybe it's 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. In fact, it's one of those cases that can be classified as "easier said than done". 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.Īll in all, there are four possible ways to switch columns in Excel, namely:Īs already mentioned, dragging columns in Excel is a bit more complex procedure than one could expect.
Surprisingly, Microsoft Excel does not provide a straightforward way to perform this common operation. 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. For example, you might need to swap a couple of columns to view their data side-by-side. If you extensively use Excel tables in your daily work, you know that whatever logical and well thought-out a table's structure is, you have to reorder the columns every now and then. The latter is often considered unfeasible, but in fact there's a tool that allows moving non-adjacent columns in Excel 365 - 2010 in a click. You will see how to drag columns with a mouse and how to move a few non-contiguous columns at a time. In this article, you will learn a few methods to swap columns in Excel.
0 kommentar(er)
