+ Reply to Thread
Results 1 to 5 of 5

How to Alphabetize one column & have the rest follow.

  1. #1
    Registered User
    Join Date
    12-05-2017
    Location
    london
    MS-Off Ver
    Office 2013
    Posts
    2

    How to Alphabetize one column & have the rest follow.

    Hi, all.


    Sounds like a simple request (maybe it is!)

    I'm looking to condense monthly spreadsheets in to one year (2017)

    I have 11 header columns & I want to alphabetize just one column (Names), but also have each column in the same row follow that one column so it all remains organised.

    Is this possible?

    Apologies if it sounds confusing.

    Thanks,

    Rob.

  2. #2
    Registered User
    Join Date
    12-05-2017
    Location
    london
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: How to Alphabetize one column & have the rest follow.

    Sorry to waste your time, I found the solution (was really simple after all)

    (in case anyone doesn't know) Highlight whole sheet - click the sort button - and specify what column you want alphabetized.

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: How to Alphabetize one column & have the rest follow.

    The options in the Sort window you can select sort left to right

    --------------------------------
    SortLeftToRight2.JPG
    Attached Images Attached Images

  4. #4
    Registered User
    Join Date
    02-06-2018
    Location
    TX
    MS-Off Ver
    2013
    Posts
    38

    Re: How to Alphabetize one column & have the rest follow.

    Post Removed by user
    Last edited by jlara0687; 09-10-2018 at 10:41 AM.

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: How to Alphabetize one column & have the rest follow.

    Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Alphabetize neighboring column while removing blank cells.
    By Big.Moe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2017, 09:22 PM
  2. How do I alphabetize a column or cell?
    By momluvs3ido in forum Excel General
    Replies: 5
    Last Post: 07-25-2015, 05:36 PM
  3. [SOLVED] How Do I Alphabetize a column but move the data in the row with it?
    By excelastrid in forum Excel General
    Replies: 2
    Last Post: 04-12-2014, 04:35 PM
  4. [SOLVED] How to lock values so I can re-alphabetize a column
    By XoddaM in forum Excel General
    Replies: 1
    Last Post: 10-21-2013, 02:24 AM
  5. [SOLVED] Alphabetize data by inner column
    By PLEASEHELPASAP in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2012, 07:45 PM
  6. Alphabetize list by column B
    By BShane in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-27-2011, 11:44 PM
  7. Macro : To find word and Select rest after this cell and delete rest
    By Zortabello in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2010, 08: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