sort

%3CLINGO-SUB%20id%3D%22lingo-sub-1948882%22%20slang%3D%22en-US%22%3Esort%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1948882%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20a%20list%20in%20excell%20that%20I%20sorted%20then%20I%20copied%20it%20to%20word%20and%20then%20added%20a%20couple%20more%20pages%20of%20words%20to%20my%20list.%20I%20moved%20my%20list%20to%20Word%20because%20I%20thought%20it%20may%20be%20easier%20for%20me.%20Anyway%20I%20can't%20get%20the%20sort%20function%20to%20perform%20now%20that%20my%20list%20is%20in%20word.%20Could%20it%20be%20anything%20to%20do%20with%20my%20transfer%20of%20my%20list%20from%20excel%20to%20word%20that%20is%20causing%20my%20problem%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1953471%22%20slang%3D%22en-US%22%3ERe%3A%20sort%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1953471%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F888574%22%20target%3D%22_blank%22%3E%40brianfton%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20replicated%20a%20couple%20scenarios%20of%20what%20you%20may%20have%20done%20to%20find%20a%20solution.%20If%20you%20used%20the%20default%20paste%20option%20when%20pasting%20your%20Excel%20list%20(keep%20source%20formatting)%2C%20that%20could%20be%20part%20of%20your%20problem%20since%20you'd%20have%20the%20Excel%20portion%20in%20a%20table%20and%20the%20added%20words%20as%20paragraph%20text.%20What%20I'd%20recommend%20doing%20is%20select%20your%20entire%20list%2C%20cut%20or%20copy%2C%20then%20paste%20as%20text%20(under%20paste%20options%2C%20it's%20the%20icon%20with%20the%20clipboard%20and%20A%20or%20select%20paste%20special%20and%20select%20unformatted%20text).%20This%20will%20remove%20any%20formatting%20from%20Excel%20that%20may%20be%20interfering%20with%20your%20sorting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20your%20added%20text%20got%20included%20in%20the%20table%20and%20you're%20selecting%20all%20then%20using%20sort%20and%20your%20default%20sorting%20option%20is%20paragraphs%2C%20try%20instead%20highlighting%20the%20table%2C%20clicking%20on%20sort%20and%20select%20column%201%20as%20the%20sort%20by%20option.%20I'd%20still%20recommend%20cutting%20and%20pasting%20the%20list%20as%20text%20to%20remove%20the%20Excel%20table%20formatting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20third%20option%20would%20be%20to%20copy%20your%20entire%20list%2C%20paste%20it%20into%20Excel%20(I%20recommend%20using%20the%20%22Match%20destination%20formatting%22%20option)%2C%20and%20just%20sorting%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20one%20of%20these%20solutions%20solves%20this%20for%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I had a list in excell that I sorted then I copied it to word and then added a couple more pages of words to my list. I moved my list to Word because I thought it may be easier for me. Anyway I can't get the sort function to perform now that my list is in word. Could it be anything to do with my transfer of my list from excel to word that is causing my problem? 

2 Replies

Hey @brianfton,

 

I replicated a couple scenarios of what you may have done to find a solution. If you used the default paste option when pasting your Excel list (keep source formatting), that could be part of your problem since you'd have the Excel portion in a table and the added words as paragraph text. What I'd recommend doing is select your entire list, cut or copy, then paste as text (under paste options, it's the icon with the clipboard and A or select paste special and select unformatted text). This will remove any formatting from Excel that may be interfering with your sorting.

 

If your added text got included in the table and you're selecting all then using sort and your default sorting option is paragraphs, try instead highlighting the table, clicking on sort and select column 1 as the sort by option. I'd still recommend cutting and pasting the list as text to remove the Excel table formatting.

 

A third option would be to copy your entire list, paste it into Excel (I recommend using the "Match destination formatting" option), and just sorting in Excel.

 

I hope one of these solutions solves this for you!

@sally365 thank you very much for these suggestions, I will try them  and let you know how it goes. Really appreciate yr help. Brian