sorting table of content

%3CLINGO-SUB%20id%3D%22lingo-sub-3446499%22%20slang%3D%22en-US%22%3Esorting%20table%20of%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3446499%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BWhen%20i%20try%20and%20sort%20my%20table%26nbsp%3B%20%26nbsp%3Bi%20am%20told%20all%20cells%20must%20be%26nbsp%3B%20the%20same%20value%26nbsp%3B%20this%20makes%20no%20sense%26nbsp%3B%20as%26nbsp%3B%20i%20am%20trying%20to%20sort%26nbsp%3B%20%26nbsp%3B%20a%20table%20with%20names%20telephone%20numbers%20and%20email%20address%20amongst%20other%20things%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3446499%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3446591%22%20slang%3D%22en-US%22%3ERe%3A%20sorting%20table%20of%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3446591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1407693%22%20target%3D%22_blank%22%3E%40davidbowen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%20it%20really%20say%20%22same%20value%22%2C%20and%20not%20%22same%20size%22%3F%3C%2FP%3E%0A%3CP%3EYou%20cannot%20sort%20if%20some%20of%20the%20cells%20in%20the%20range%20are%20merged%20an%20others%20aren't.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

 When i try and sort my table   i am told all cells must be  the same value  this makes no sense  as  i am trying to sort    a table with names telephone numbers and email address amongst other things  

1 Reply

@davidbowen 

Does it really say "same value", and not "same size"?

You cannot sort if some of the cells in the range are merged an others aren't.