Forum Discussion
zipperzizzinski
Apr 18, 2022Copper Contributor
Excel data sorting
This may be an elementary process, but can anyone tell me how to sort columns of random order part numbers into numerical order, whilst also moving the associated data for each part number in each r...
HansVogelaar
Apr 18, 2022MVP
Do not select the entire part number column when you want to sort by it.
Instead, either click in a single cell in the part number column, or select the entire range to be sorted, then use the Tab key to move the active cell to the part number column. Then sort.
zipperzizzinski
Apr 24, 2022Copper Contributor
HansVogelaar Thanks for the suggestion, although I could not implement it as described I did manage to muddle through.