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 2016, 20 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 Comments
Leave a Reply. |