Forum Discussion
locking and sorting rows
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 |
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,
