Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: keeping rows together when ordering order of left column
in my spreadsheet I want to order the left hand column (in ascending numbers)
but when I do I want the rows to move with cells too, keeping the items of data in the rows with the original items of data in the left hand cells when they move place |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: keeping rows together when ordering order of left column
Select the data say A1:J10 and then from menu DataSort
--If your data has headers then select 'My data range has' headers .. --Select 'Sortby'..and hit OK -- Jacob "Tangojon" wrote: in my spreadsheet I want to order the left hand column (in ascending numbers) but when I do I want the rows to move with cells too, keeping the items of data in the rows with the original items of data in the left hand cells when they move place |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort column by date but keeping all rows locked | Excel Discussion (Misc queries) | |||
Print Titles: Repeating both left column and top rows | Excel Discussion (Misc queries) | |||
how do I view excel rows in name order infirst column? | Excel Worksheet Functions | |||
keeping rows together during column sorts of linked worksheets | Excel Worksheet Functions | |||
moving alternating rows to a column with the order staying the sam | Excel Discussion (Misc queries) |