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: ...
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,