locking and sorting rows

[BARFRODEO]

Is there a way to lock the data of two rows to be able to sort the rows locked together?  I am needing to be able to sort by the totals showing at the end of the 1st of the two rows.

example below:

20.5	21	20	20.50	82.00	8	90.00	169.99
20	20.5	17	19.17	76.67	3.32	79.99
21.25	21.75	21.5	21.50	86.00	2.56	88.56	178.56
20.5	20	21	20.50	82.00	8	90.00
17.25	12	17	15.42	61.67	8	69.67	162.33
21.25	21.25	21	21.17	84.67	8	92.67
21.5	21.75	21.5	21.58	86.33	7.44	93.77	185.773
20.5	21.5	21	21.00	84.00	8	92.00

[#2]

@BARFRODEO 

You'd have to copy the totals to the empty cell below.

For example:

• Select the totals column.
• Press F5 to activate the Go To dialog.
• Click Special...
• Select Blanks, then click OK.
• Note the address of the active cell - it is displayed on the left hand side of the formula bar.
• Let's say it is H3.
• Enter the formula =H2, referring to the cell above the active cell.
• Confirm by pressing Ctrl+Enter to populate all the empty cells.

You can now sort safely,