Home

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
giandaborgo1947
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

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,

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies