This article has been written in response to a readers question.
When I take a spreadsheet that someone else has created & remove some unwanted columns & rows, add a notes column of my own outside of the last column of their original spreadsheet, it won’t pick up that last “notes” column when it sorts. If I highlight the entire document it will, but most people don’t highlight the whole thing when they sort. We share this document with other people, they sort it and don’t realize that they didn’t sort the notes field. Do you know of a fix to include the extra added “notes” column in the “my data has headers” “sort by” option that will travel with the document?