Why did sorting the names leave our spreadsheet's other columns with the wrong people?
TechnologyThe names are alphabetical now, but my colleague spotted that her shift was beside somebody else. I selected the name cells in Excel and chose to continue with the current selection when a warning appeared.
The worksheet holds names, shifts and meal choices in neighbouring columns. I thought the warning was about which names I wanted sorted. Microsoft's guidance warns that sorting part of a larger range can separate it from its associated data. Excel's sorting guidance
I haven't sent the sheet to the caterer, and we have an earlier copy. How should I restore the relationships and sort the list safely? Alphabetical names are no use if the rest of each row belongs to someone else.