Sort data by selecting entire row, but lock frist two columns

[VonnerNIX]

I have a table setup where the first 2 columns in my table need to stay in place, but I need to select the rest of the columns from, say row 2-100. So basically I am selecting C2:DD100 and I need to sort that by the data in row 100. I know this is possible by dragging and selecting from C2 to DD100, but I was wondering if I could lock the first to 2 columns and just have to select the ENTIRE rows 2-100? This would save a lot of time.

I know this can be done with macros, but I am trying to stay away from that, as I would also like to be able to undo this (and with macros it is harder to undo than a regular sort)

[olasa]

There is even a faster way:

Write C2:DD100 in the "position selector" (see enclosed picture)
...then sort

Ola Sandström