Xcel

%3CLINGO-SUB%20id%3D%22lingo-sub-633609%22%20slang%3D%22en-US%22%3EXcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633609%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20with%20several%20rows%20and%20columns.%26nbsp%3B%20The%20first%20column%20is%20a%20date.%26nbsp%3B%20I%20would%20like%20to%20sort%20the%20table%20into%20date%20order%20starting%20with%20the%20earliest%20date%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-633609%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633659%22%20slang%3D%22en-US%22%3ERe%3A%20Xcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F346649%22%20target%3D%22_blank%22%3E%40Alan7208%3C%2FA%3E%26nbsp%3B%2C%20I%20guess%20that's%20a%20range.%20Select%20the%20column%20and%20on%20ribbon%20Data-%26gt%3BSort%20A-Z%20with%20expanding%20selection%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633668%22%20slang%3D%22en-US%22%3ERe%3A%20Xcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633668%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Alan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%26nbsp%3Beasily%20do%20sort%20in%20Excel!%3C%2FP%3E%3CP%3EPlease%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fsort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%20to%20get%20started.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F346649%22%20target%3D%22_blank%22%3E%40Alan7208%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Alan7208
Occasional Visitor

I have a table with several rows and columns.  The first column is a date.  I would like to sort the table into date order starting with the earliest date?

2 Replies

@Alan7208 , I guess that's a range. Select the column and on ribbon Data->Sort A-Z with expanding selection

Hi Alan,

 

You can easily do sort in Excel!

Please check out this link to get started. 

 

Hope that helps

 

@Alan7208 

Related Conversations