Lock row in place
 

Is it possible to lock a row in place so that when I sort the entire sheet it
stays in the bottom.

Lock row in place
 

You could exclude it from your sort range.

Or, you could amend the sort key for that row by appending "ZZZ" to
the beginning of it - it will always be sorted to the bottom.

Hope this helps.

Pete

On Mar 8, 12:34 pm, Dennis1188
wrote:
Is it possible to lock a row in place so that when I sort the entire sheet it
stays in the bottom.

Lock row in place
 

The "ZZZ" idea worked great... Thanks.

"Pete_UK" wrote:

You could exclude it from your sort range.

Or, you could amend the sort key for that row by appending "ZZZ" to
the beginning of it - it will always be sorted to the bottom.

Hope this helps.

Pete

On Mar 8, 12:34 pm, Dennis1188
wrote:
Is it possible to lock a row in place so that when I sort the entire sheet it
stays in the bottom.