How to Re-arrange Columns with Column Manager
Column Manager lets you change the order of columns on the fly, without manual copying/pasting or learning a handful of shortcuts.
- With the Ultimate Suite installed in your Excel, click the Column Manager and there you can wait for a while.
- The Column Manager’s pane will appear on the right side of the Excel window and display a list of columns that are present in your active worksheet.
- To move one or more columns, select them on the pane and click the Up or Down arrow. The former moves the selected columns to the left in your sheet, the latter to the right:
Or, drag and drop the columns on the pane with your mouse. All the manipulations that you do on the Column Manager pane are simultaneously performed on your worksheet, which lets you visually see all the changes and have full control over the process.
Autofit column width – Click this icon to auto-fit the width of the selected columns.
Insert a new column – Click this icon to insert a new column.
How to Swap Columns in Excel
Column swapping in Excel seems like a hectic task. Well, now it has been made a bit simple because of some new methods by which you can just swap the columns and do your need full work more efficiently. In this article, you will learn how to drag columns and how to move them. If you extensively use Excel tables in your daily work, you know that whatever logical and well-thought-out a table’s structure is, still you have to reorder your columns and credentials every now and then.
Table of Content
- How to Swap Columns in Excel
- How to Drag Columns in Excel
- How to Move Several Columns in Excel
- How to Swap Columns by Dragging Several Columns Using the Mouse
- How to Swap Columns Using Cut and Paste Columns Individually
- How to Swap Multiple Columns By Copying, Pasting, and Deleting in Excel
- How to Re-arrange Columns with Column Manager
- How to Swap Columns in Excel Shortcut
Contact Us