the simple answer is to select all before you sort.
there are other things you can do such as writing a macro to ensure you
select all before sort
you can use auto filter sort and all will be sorted.
the only question is how complex do you need to be

"Dave86" wrote:

We have a spreadsheet with approx. 3000 rows and 9 columns.

We want to sort the data so that the "row data" always stays in tact.
And then go back to when column "A" is back in alphabetical order, again.

EXAMPLE: If we want to sort for a certain gearbox or coupling.
We want ALL the date in each row kept in tact, so we can see what jobs use
the same gearbox or coupling, when sorted.
You can email me if you want..
I can send a copy of the spreadsheet if you like, or helpful.
Thanks,
Dave Clemens