A-Z sort not working

Occasional Visitor

I'm in Windows 10, Office 365.  I have a multi tab spread sheet & copied a specific column from 5 of the tabs into a new tab & am trying to sort it A-Z.  It will sort the info from the 1st 4 tabs, but does NOT sort the info from the 5th tab in with the others.  I have tried the following: 

  • checked that there weren't any leading spaces
  • removed all fill/color coding
  • =CLEAN formula
  • pasted the info that wouldn't sort into the middle of the info that was sorting

Ultimately, I would like it to sort A-Z with color coding  so I can see if a group name is showing on one or more tabs. (there is probably a more smarty pants way to do this....maybe a pivot of some sort but I'm not skilled with those yet)


Any input would be appreciated  

0 Replies