+ Reply to Thread
Results 1 to 3 of 3

Is there a way to seperate the table from the rest of the cells?

  1. #1
    Registered User
    Join Date
    12-09-2013
    Location
    Tennesse
    MS-Off Ver
    Excel 2010
    Posts
    14

    Is there a way to seperate the table from the rest of the cells?

    Im using a table so I can sort diffrent catagories and I'm trying to put other functions to the right of the table I noticed as I change the sort on the table is moves the information outside the table as well is there a way to seperate that information or do I just need to move it above my table?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,613

    Re: Is there a way to seperate the table from the rest of the cells?

    When you sort, you sort the rows, not just the table so anything alongside the table will be sorted too.

    Depends what you have next to the table. If it is reference information, it would be better on a separate sheet.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    12-09-2013
    Location
    Tennesse
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Is there a way to seperate the table from the rest of the cells?

    It is refrence information that pulls its data from the table.

+ 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: 1
    Last Post: 05-28-2013, 07:56 PM
  2. Seperate Values in single cell seperated by [alt+enter] into seperate cells
    By Coquito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2012, 04:24 PM
  3. 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
  4. Replies: 0
    Last Post: 04-12-2007, 09:56 AM
  5. Replies: 1
    Last Post: 03-07-2005, 08:36 PM

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