View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.