Results 1 to 11 of 11

Arrange columns by alphabetical column names

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Arrange columns by alphabetical column names

    Is there a quick way to re-arrange the data (in a Table, as in defined Excel Table) so all column names/headers appear alphabetically?
    (in my case, the data has as many as 50 columns, so it is kinda time-consuming to drag and drop them around to get them in that order).

    in the attached sample, though the column headers are numbers, but should suffice the purpose.
    Attached Files Attached Files
    Last edited by jewelsharma; 01-05-2018 at 01:30 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to Re-arrange the Items in Alphabetical Order?
    By jalalsalik in forum Excel General
    Replies: 2
    Last Post: 09-30-2015, 02:32 AM
  2. [SOLVED] Help! Same Names Merge into One then arrange the description by column
    By James Ray in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-04-2015, 10:26 AM
  3. Arrange columns of names & addresses into rows
    By SKMaverick in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-04-2010, 02:36 PM
  4. Replies: 3
    Last Post: 05-03-2006, 08:25 PM
  5. How to arrange your tabnames in alphabetical / chronological order
    By Dbase Beginner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2005, 09:12 AM
  6. How do I arrange sheets in alphabetical order?
    By Supreme Grace in forum Excel General
    Replies: 2
    Last Post: 03-16-2005, 01:06 PM
  7. [SOLVED] How do I arrange sheets in alphabetical order?
    By gracebakky in forum Excel General
    Replies: 2
    Last Post: 03-16-2005, 07:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1