how to organize cells in alphabetic order (a>z)

%3CLINGO-SUB%20id%3D%22lingo-sub-690748%22%20slang%3D%22en-US%22%3Ehow%20to%20organize%20cells%20in%20alphabetic%20order%20(a%26gt%3Bz)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690748%22%20slang%3D%22en-US%22%3E%3CP%3Eai%20have%20a%20column%20of%20excel%20full%20of%20german%20words%20%2C%20random%20disposed%20.....ai%20would%20like%20to%20organize%20this%20column%20in%20alphabetic%20order%20%2C%20but%26nbsp%3B%20%2Cany%20time%20a%20get%20to%20the%20end%20of%20process%20%2C%20excel%20tells%20me%20%3A%20you%20need%20to%20have%20all%20the%20cells%20in%20the%20same%20dimension..!!!!................so%20ai%20choosed%20a%20big%20dimension%20of%20the%20cell%20of%20the%20column%20.....for%20exemple%20100%20high%20....all%20100%20high...........BUT%20AI%20GET%20NOTHING.............%20AND%20AI%20DO%20NOT%20KNOW%20WHAT%20TO%20DO...thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-690748%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-690753%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20organize%20cells%20in%20alphabetic%20order%20(a%26gt%3Bz)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690753%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20sounds%20like%20you%20have%20merged%20cells%20in%20your%20data.%20If%20you%20select%20all%2C%20then%20go%20to%20%3CSTRONG%3EFormat%20%26gt%3B%20Cells%20(Ctrl%2B1)%2C%20Alignment%20%26gt%3B%3C%2FSTRONG%3E%20uncheck%20%3CSTRONG%3EMerge%20cells%3C%2FSTRONG%3E%2C%20you%20should%20be%20able%20to%20sort%20OK.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

ai have a column of excel full of german words , random disposed .....ai would like to organize this column in alphabetic order , but  ,any time a get to the end of process , excel tells me : you need to have all the cells in the same dimension..!!!!................so ai choosed a big dimension of the cell of the column .....for exemple 100 high ....all 100 high...........BUT AI GET NOTHING............. AND AI DO NOT KNOW WHAT TO DO...thanks

1 Reply
Highlighted

It sounds like you have merged cells in your data. If you select all, then go to Format > Cells (Ctrl+1), Alignment > uncheck Merge cells, you should be able to sort OK. 

 

Hope that helps,