+ Reply to Thread
Results 1 to 5 of 5

connecting cells (item no./item description)

  1. #1
    Registered User
    Join Date
    06-22-2015
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    2

    Exclamation connecting cells (item no./item description)

    i am making a inventory supply list. i want to connect a cell in the first column to a cell in the second column so when i want to sort using the item number or the item description the cells move with the corresponding cells. how would i do this? sorry i am new to excel and to this forum. so hello everyone and thank you in advance for your help to this simple issue! have a great day!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: connecting cells (item no./item description)

    Just select a cell in one of the columns - Data ribbon - Click the Sort Icon - Check or uncheck " My Data has headers" and select how you want to sort. It will follow automatically

  3. #3
    Registered User
    Join Date
    09-16-2013
    Location
    Austin, Texas, USA
    MS-Off Ver
    Excel 2007 Home
    Posts
    17

    Re: connecting cells (item no./item description)

    When you select your range to be sorted, just include both columns. For example, if your item numbers are in the range B2:B500 and the corresponding item descriptions are in the range C2:C500, select range B2:C500. Select Sort in the Sort & Filter section under the Data tab. In the Sort dialog box choose Sort on Column B if you want to sort by number or Sort on Column C if you want to sort by description. The data in each row will still be in a row together when the sort is complete.

  4. #4
    Registered User
    Join Date
    06-22-2015
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    2

    Re: connecting cells (item no./item description)

    wow haha! i knew it was simple, but it just moved the one column the first time i tried. thank you! have a wonderful day!

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: connecting cells (item no./item description)

    Selecting the entire table is not mandatory. One cell suffices

+ 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. Align an item name from its short description via keywords
    By kissmydrone in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2014, 03:55 AM
  2. Replies: 2
    Last Post: 10-14-2014, 07:12 AM
  3. Creating a part number from an item description
    By yr25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2013, 12:13 PM
  4. [SOLVED] Item Description
    By Aussie1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2013, 05:35 PM
  5. Replies: 5
    Last Post: 07-26-2011, 10:35 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