close

I have a definition database i am about to organize alphabetically. Is
there a way i can lock two cells together so when the rows in one cell
are organized, they stay with the cell beside them (one cell has word,
one has definitions)--
everlong


Try this,

Select the data you want sorted (the 2 columns) including the first
row that include the title (ie: word meaning)

1)Go to the menu Data
2)Click on sort
3)Tick My list has header row.

then you will see that for the choice of sorting you will have word and
meaning. Then when you sort the pair for each row will keep together.

Francoise--
sunnyland
------------------------------------------------------------------------
sunnyland's Profile: www.excelforum.com/member.php...oamp;userid=30871
View this thread: www.excelforum.com/showthread...hreadid=505608

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()