+ Reply to Thread
Results 1 to 7 of 7

linking cells together

  1. #1
    Registered User
    Join Date
    06-09-2013
    Location
    lebanon
    MS-Off Ver
    Excel 2007
    Posts
    95

    linking cells together

    hi i have created a table and there are 4 columns in the table

    item,cost,price,earning

    however, whenever i sort one column, from smallest to largest, the other columns are not adjusting themselves accordingly.

    so my question is, how can i link 4 cells together horizontally, so whenever i sort anyone of the 4 cells, the other 3 cells which are in relation to their rows, will sort too

    it would be much appreciated if someone helped me out, thank you

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: linking cells together

    Hi
    Before you click on "Sort" make sure that you select the whole range of data. That way the complete row will stay together.
    Tony

  3. #3
    Registered User
    Join Date
    06-09-2013
    Location
    lebanon
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: linking cells together

    oh well i was wondering isn't there a way to permanently link them ? like one sort will move the whole cells ?

  4. #4
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    139

    Re: linking cells together

    Select all of your data
    Under the home tab there is a section called Styles
    Click on "Format as table"
    Select a color scheme from the drop down.

    That should do what you are looking for

  5. #5
    Registered User
    Join Date
    06-09-2013
    Location
    lebanon
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: linking cells together

    hey thx for the help im really greatful but unfortunately i cant find this styles, all i see under the home tab is. cut, copy, format painter, and left to it theres the big paste button and under it a flash which provides u multiple ways to paste. can u help me plz

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: linking cells together

    Excel 2007 =>
    insert ( 3 third option on the lint)
    table (2 second option ont the lint)
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  7. #7
    Registered User
    Join Date
    06-09-2013
    Location
    lebanon
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: linking cells together

    hey thx alot bro it worked, i used a table and inserted it and it seems to be working by changing one column its changing the other columns too thx
    Last edited by raffi123; 06-16-2013 at 10:53 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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