I need to sort an entire workbook of data except 1 column and the header. I can easily not sort the header but I need to freeze that one column so that all the data sorts except that column. Is this possible?
Yes the column is at the far left. The problem is that I need to make this for a group of people who are not Excel literate. So in doing that I was hoping there was a way I could freeze/lock that column that way they can not sort it but can sort the rest of the document, like the header row.
Will they always sort by the same column? If so, record a macro doing the sorting this way. Then using the drawing toolbar, add a shape, probably a rectangle or an oval and assign the macro you recorded to it. This is the very basics to get you started.
If you can get this far, you can always post back with more specific questions to handle things like changing number of rows, allowing the sorting on various columns, etc.