How to manage columns in Excel

If you work with tables that have numerous columns, you might want to easily change their order without copying and pasting each column separately. The Column Manager tool creates a list of all columns so that you can easily navigate, autofit, and drag them.

Before you start

We strongly recommend creating a backup copy of your sheet. After moving or deleting columns, you won't be able to undo the changes.

Start Column Manager

Open the worksheet that contains the columns you want to manage. To start the add-in, click the Column Manager icon on the Ablebits Data tab, in the Manage group:
Start Column Manager from Ultimate Suite for Excel.

Manage your Excel columns

You can see the Column Manager pane with the list of columns in the selected table. Here you'll find your column headers under Name, Excel column letters under Column, and range addresses under Range:
The Column Manager pane

  • To select a column in your table, click it in the list.
  • To change the column order in your table, drag the columns to the needed position in the list.
  • Alternatively, you can move the column(s) by selecting them in the add-in pane and using the Ctrl+Up arrow or Ctrl+Down arrow shortcuts.
  • To make a column the first one or the last one in your table, select it in the add-in pane and use the Ctrl+Home and Ctrl+End shortcuts accordingly.
  • To autofit your columns, select them in the add-in pane and press the Ctrl+Right arrow keyboard shortcut.
Tip. Press the Ctrl button on your keyboard to select several columns and manage them all at once.

Besides, you can use the icons at the top of the pane:
The Column Manager toolbar

  1. To move the column(s) to the left or to the right, select the column(s) of interest and click the Move Up or Move Down icon.
  2. To move the column(s) to the far left or to the far right in your table, select them and use the Move to Top or Move to Bottom icon.
  3. You can make the column width automatically fit its longest entry by clicking the Auto Fit icon.
  4. If you need to add a column, select an existing one in the add-in pane or in the worksheet and click the Insert icon. The new column will appear to the right of the initially selected one.
  5. To remove a column, click on it in the add-in pane or in your worksheet and click the Delete icon.
Note. The Column Manager tool doesn't work with filtered columns so as not to break the structure of your worksheet. If you have a filter applied, remove it before using Column Manager.



Why do the actual names (headers) of columns not show up in Column Manager on some sheets? Those sheets that I have with very large numbers of columns do not reflect a name, and those are the ones I need it most.

Hello Court,

Thank you for contacting us.

For us to be able to help you better, please send us a sample of your workbook to, so we could look into it and see how your data is arranged.

Please don't worry if you have confidential information there, we never disclose the data we get from our customers and delete it as soon as the problem is resolved. Or you can replace any important information with some irrelevant data, just keep the format.

We'll do our best to solve the issue.

Larry w Scruggs says:
November 4, 2019 at 1:10 pm

I need to select multiple items from a excel drop down list. And not allow duplicates. Have read watched a couple videos and still can't make it work.

Albert William says:
August 11, 2019 at 2:06 pm

How can you copy and paste every other row in Excel.

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at