SOLVED

Partial sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-1563235%22%20slang%3D%22en-US%22%3EPartial%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563235%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20have%20a%20long%20table%2C%20i%20want%20to%20sort%20by%20date%20BUT%20i%20don't%20want%20to%20sort%20the%20whole%20column%2C%20only%20rows%2022%20to%20480.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1563235%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563284%22%20slang%3D%22de-DE%22%3ESubject%3A%20Partial%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563284%22%20slang%3D%22de-DE%22%3ESort%20by%20what%3F%20Numeric%2C%20alphabetical%2C%20ascending%2C%20descending%3F%20%3CBR%20%2F%3E%20It%20is%20always%20good%20to%20include%20a%20worksheet%20(without%20sensitive%20data).%20This%20can%20help%20you%20better%20because%20we%20can%20help%20better.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thx%20%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563295%22%20slang%3D%22en-US%22%3EBetreff%3A%20Partial%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563295%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%20now%20is%20just%20by%20date%2C%20but%20it%20could%20be%20by%20some%20other%20reason.%20Lets%20say%20I%20want%20to%20sort%20from%20row%203%20to%20row%2010%20in%20this%20table%2C%20and%20leave%20the%20other%20rows%20in%20the%20same%20location.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%2292%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2292%22%3E7%2F17%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%2F19%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%2F30%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E7%2F13%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E7%2F17%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6%2F22%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%2F12%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%2F9%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E7%2F22%2F20%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563313%22%20slang%3D%22de-DE%22%3ESubject%3A%20Partial%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563313%22%20slang%3D%22de-DE%22%3EMaybe%20this%20will%20help%20you%20quickly%20%3CBR%20%2F%3E%20manual%20for%20Sort%20data%20in%20a%20range%20or%20table%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fsort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fsort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20find%20this%20helpful%2C%20please%20mark%20it%20as%20%22Best%20Answer%22%20and%20as%20Like%20(click%20thumbs%20up)%2C%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563327%22%20slang%3D%22de-DE%22%3ESubject%3A%20Partial%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563327%22%20slang%3D%22de-DE%22%3ESort%20dates%20or%20times%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Select%20a%20cell%20in%20the%20column%20you%20want%20to%20sort.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20On%20the%20Data%20tab%2C%20in%20the%20Sort%20%26amp%3B%20Filter%20group%2C%20do%20one%20of%20the%20following%3A%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20To%20sort%20from%20an%20earlier%20to%20a%20later%20date%20or%20time%2C%20click%20A%20to%20Z%20command%20in%20Excel%20that%20sorts%20A%20to%20Z%20or%20smallest%20number%20to%20largest%20(Sort%20Oldest%20to%20Newest).%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20To%20sort%20from%20a%20later%20to%20an%20earlier%20date%20or%20time%2C%20click%20Z%20to%20A%20command%20in%20Excel%20that%20sorts%20Z%20to%20A%20or%20largest%20number%20to%20smallest%20(Sort%20Newest%20to%20Oldest).%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20You%20will%20find%20all%20the%20information%20about%20sorting%20in%20the%20address%20I%20sent%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20If%20you%20find%20this%20helpful%2C%20please%20mark%20it%20as%20%22Best%20Answer%22%20and%20as%20Like%20(click%20thumbs%20up)%2C%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563335%22%20slang%3D%22en-US%22%3EBetreff%3A%20Partial%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563335%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIts%20useful%20but%20the%20guide%20says%20it%20does%20not%20work%20with%20tables%2C%20and%20this%20is%20a%20table%20im%20working%20with%20so%20I%20need%20a%20workaround.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563352%22%20slang%3D%22de-DE%22%3ESubject%3A%20Partial%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563352%22%20slang%3D%22de-DE%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CEM%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20a%20small%20example%20worksheet%20with%20your%20own%20date.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20find%20this%20helpful%2C%20please%20mark%20it%20as%20%22Best%20Answer%22%20and%20as%20Like%20(click%20thumbs%20up)%2C%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563367%22%20slang%3D%22de-DE%22%3ESubject%3A%20Partial%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563367%22%20slang%3D%22de-DE%22%3EUse%20the%20Sort%20command%20%3CBR%20%2F%3E%20Go%20on%20dates%20and%20then%20sort%20and%20filter%20Click%20on%20Advanced%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Popup%20menu%20opens%20special%20filters%20Now%20%3CBR%20%2F%3E%20you%20can%20set%20the%20criteria%20as%20required.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563462%22%20slang%3D%22de-DE%22%3ERE%3A%20Partial%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563462%22%20slang%3D%22de-DE%22%3EI%20was%20happy%20to%20help%20you.%20At%20your%20service%20Nikolino%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Hello. I have a long table, i want to sort by date BUT i don't want to sort the whole column, only rows 22 to 480.

 

Is there any way to do this?

8 Replies
Highlighted
Sort by what? Numeric, alphabetical, ascending, descending?
It is always good to include a worksheet (without sensitive data). This can help you better because we can also help better.

Thx
Nikolino
I know I don't know anything (Socrates)
Highlighted

@Nikolino 

 

Right now is just by date, but it could be by some other reason. Lets say I want to sort from row 3 to row 10 in this table, and leave the other rows in the same location.

 

7/17/20
2/19/20
3/30/20
7/13/20
7/17/20
6/22/20
2/12/20
3/9/20
7/22/20
Highlighted
Maybe this will help you quickly
manual for
Sort data in a range or table
https://support.microsoft.com/en-gb/office/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e5...

If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.

Nikolino
I know I don't know anything (Socrates)
Highlighted
Sort dates or times

Select a cell in the column you want to sort.

On the Data tab, in the Sort & Filter group, do one of the following:

To sort from an earlier to a later date or time, click A to Z command in Excel that sorts A to Z or smallest number to largest (Sort Oldest to Newest).

To sort from a later to an earlier date or time, click Z to A command in Excel that sorts Z to A or largest number to smallest (Sort Newest to Oldest).

You will find all the information about sorting in the address I sent you

If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.

Nikolino
I know I don't know anything (Socrates)
Highlighted

@Nikolino 

 

Its useful but the guide says it does not work with tables, and this is a table im working with so I need a workaround.

Highlighted
Best Response confirmed by Ocasio27 (Frequent Contributor)
Solution

 

 

Here is a small example worksheet with your own date.

 

 

If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.

 

Nikolino

I know I don't know anything (Socrates)

Highlighted
Use the Sort command
Go on dates
and then sort and filter
Click on Advanced
Popup menu opens special filters
Now you can set the criteria as required.
Highlighted
I was happy to help you. At your service Nikolino I know I don't know anything (Socrates)