+ Reply to Thread
Results 1 to 3 of 3

One column doesn't sort with the other columns

  1. #1
    Registered User
    Join Date
    08-13-2014
    Location
    England
    MS-Off Ver
    MS office 2013
    Posts
    2

    One column doesn't sort with the other columns

    Firstly I'm pretty new to Excel (2013) and trying to teach myself by trial and error and using google.
    I have created a table with several columns and rows but whenever I select all the data and try to sort it the last column doesn't sort along with the others.
    If you select all the data the option in "DATA/SORT" is greyed out.
    I've searched but can't seem to find an answer.
    I'm sure its something obvious.
    I have attached the file - its the last column, "Link to failure" that somehow seems disconnected from the rest.
    Thanks
    Attached Files Attached Files
    Last edited by Boygroucho; 08-13-2014 at 09:54 AM.

  2. #2
    Forum Contributor
    Join Date
    11-26-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    116

    Re: One column doesn't sort with the other columns

    When you're in your table, press the DESIGN tab. You'll see on the left that for the most part, your table is called Table1.

    However, place cursor in a cell that corresponds to your last column and... it's another table. Select Table2, click "convert to range" (you're in the right tab already). Now place cursor in Table1 and resize it. Should be good to go!

  3. #3
    Registered User
    Join Date
    08-13-2014
    Location
    England
    MS-Off Ver
    MS office 2013
    Posts
    2

    Re: One column doesn't sort with the other columns

    Brilliant thanks for your help.

+ 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. Replies: 2
    Last Post: 01-15-2014, 09:31 AM
  2. Replies: 5
    Last Post: 04-25-2013, 11:50 PM
  3. [SOLVED] Text-to-Columns doesn't work well when column is selected
    By mexindian in forum Excel General
    Replies: 17
    Last Post: 04-18-2013, 08:55 AM
  4. Replies: 1
    Last Post: 11-06-2012, 07:07 PM
  5. Sorting at two columns (Advanced Sort doesn't help)
    By shashjindal in forum Excel General
    Replies: 3
    Last Post: 12-16-2011, 02:18 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