Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to lock cells together while organizing?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to lock cells together while organizing?
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: http://www.excelforum.com/member.php...o&userid=30871 View this thread: http://www.excelforum.com/showthread...hreadid=505608 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
How do I lock all cells in Excel except 2 which I need unlocked? | Excel Discussion (Misc queries) | |||
Select Range of Cells | Excel Discussion (Misc queries) | |||
Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |