Quick Tools for Microsoft Excel

Easily navigate among the columns in your table, move them by drag-and-dropping

Moving columns in Microsoft Excel
Free Download
Free 15-day trial version, 9/8/2014

How to manage columns

If you work with tables that have numerous columns, you may want to easily change their order without copying and pasting one column at a time. The Column Manager tool allows you to open a list of columns to easily navigate, auto fit and move them by drag-and-dropping:

  1. Select the table where you need to manage columns.

    Tip

    Tip: You can choose one cell in your spreadsheet so when you open the tool it will automatically pick all the columns in the table.

  2. Click on the Column Manager icon Click on the Column Manager icon to open the tool to run the tool. You will see a window with the list of columns from the selected table. Here you will find column names (the headers), column letters and their range addresses. See the list of columns from the selected table
  3. If you need to navigate to a particular column in your table, click on the necessary column in the list on the Column Manager window and close the window to leave the column selected in your Excel table. Select a column in the list to navigate to it in your tablee
  4. The easiest way to change the column order in your table is drag-n-dropping column(s) to the needed position on the Column Manager window. Move a column to the needed location by drag-n-dropping it in the list of columns

    Tip

    Tip: You can press the Ctrl or Shift button on your keyboard and select several columns to move them all at the same time.

    Select several columns to move them all at the same time
    Another way of moving the columns is using the icons at the top of the Column Manager window. Use these icons to move or auto fit the columns in your Excel table Simply select the column(s) you want to move in the list and perform the necessary action:
    • To move the column(s) to the left in your spreadsheet, click the Move Up icon on the Column Manager window.
      Move the column(s) to the left on your spreadsheet by clicking the Move Up icon
      You can also right-click on the column you want to move and select the Move Up option from the menu.
      Choose this option to move a column to the left
      You will get the same result by using the Ctrl + Up arrow keyboard shortcut.
    • If you need to move the column(s) to the right in your Excel table, click the Move Down icon on the window.
      Move the column(s) to the right on your spreadsheet by clicking the Move Down icon
      You can also right-click on the column(s) you want to move and select the Move Down option from the menu.
      Pick this option to move a column to the right
      One more possibility to do the same is to press the Ctrl + Down arrow keyboard shortcut.
    • To move the necessary column(s) to the far left of your table, select the Move to Top icon on the window.
      Move the column(s) to the left on your spreadsheet by clicking the Move to Top icon
      You can also right-click on the necessary column(s) and select Move to Top from the list.
      Choose this option to move a column to the far left
      Pressing Ctrl + Home will give the same result.
    • If you need to move the column(s) to the far right of your table, select the Move to Bottom icon on the window.
      Move the column(s) to the far right on your spreadsheet by clicking the Move to Bottom icon
      Or right-click on the column and select the Move to Bottom option from the menu.
      Pick this option to move a column to the far right
      It is also possible to get the same result by pressing Ctrl + End on your keyboard.
  5. You canAutoFit a column so that it automatically fits its longest entry:
    • Select the necessary column(s) in the list on the Column Manager window.

      Tip

      Tip: You can press the Ctrl or Shift button on your keyboard and select several columns to Auto Fit them all at the same time.

    • Click on the Auto Fit icon on the Column Manager window. Click on this icon to auto fit the columns You can also right click on the column(s) you need to auto fit and select the Auto Fit option from the menu list. Pick this option to auto fit the columns One more possibility is to use the Ctrl + Right arrow keyboard shortcut.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
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
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