![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |