Is it possible to lock a row in place so that when I sort the entire sheet it stays in the bottom.
D Dennis1188 Mar 8, 2007 #1 Is it possible to lock a row in place so that when I sort the entire sheet it stays in the bottom.
P Pete_UK Mar 8, 2007 #2 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
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
D Dennis1188 Mar 8, 2007 #3 The "ZZZ" idea worked great... Thanks. Pete_UK said: 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 Click to expand...
The "ZZZ" idea worked great... Thanks. Pete_UK said: 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 Click to expand...
