How to manage columns in Excel

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

Before you start

We strongly recommend creating a backup copy of your sheet. Always remember: after moving or deleting columns, you will not 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 will find the column names (the headers or standard Excel letters) and the range they take:

The Column Manager pane.

  • To navigate to the needed column, click on it in the list and it will be automatically selected in your table.
  • To change the column order in your table, drag-and-drop the columns to the needed position in the list.
  • Another way to move the columns is selecting the needed one(s) 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 automatically, 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, i.e. to put them first or last, 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 does not work with filtered columns not to break the structure of your worksheet. If you have a filter applied, just remove it and then use Column Manager.

Responses

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

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

Reply

Hello Albert,
Thank you for contacting us.

We have some useful tutorials on how to copy and move sheets in Excel or enter the same data (formula) into all selected cells at a time on our blog. Maybe you'll find this information helpful.

If however, this is not exactly what you need, please describe your task in more detail and we'll find a better solution for you. Thank you.

Reply
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.

Reply

Hello Larry,
Thank you for your comment.

I'm sorry, but your task is not entirely clear. Could you please describe it in more detail? If you send us a small sample workbook with your source data and the result you expect to get to support@ablebits.com, it will help us understand it better and find the solution for you. Thank you.

Reply

Ask a question (posted publicly)

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 support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard