资源描述：
《sort data in a range or table排序范围或表格中的资料》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。
1、SortdatainarangeortableSortingdataisanintegralpartofdataanalysis.Youmightwanttoputalistofnamesinalphabeticalorder,compilealistofproductinventorylevelsfromhighesttolowest,ororderrowsbycolorsoricons.Sortingdatahelpsyouquicklyvisualizeandunderstandyourdatabetter,organi
2、zeandfindthedatathatyouwant,andultimatelymakemoreeffectivedecisions. NOTE Tofindthetoporbottomvaluesinarangeofcellsortable,suchastop10gradesorbottom5salesamounts,useAutoFilterorconditionalformatting.LearnaboutsortingYoucansortdatabytext(AtoZorZtoA),numbers(smalles
3、ttolargestorlargesttosmallest),anddatesandtimes(oldesttonewestandnewesttooldest)inoneormorecolumns.Youcanalsosortbyacustomlist(suchasLarge,Medium,andSmall)orbyformat,includingcellcolor,fontcolor,oriconset.Mostsortoperationsarecolumnsorts,butyoucanalsosortbyrows.Sort
4、criteriaaresavedwiththeworkbooksothatyoucanreapplythesorteachtimethatyouopentheworkbookforanExceltable,butnotforarangeofcells.Ifyouwanttosavesortcriteriasothatyoucanperiodicallyreapplyasortwhenyouopenaworkbook,thenit'sagoodideatouseatable.Thisisespeciallyimportantfo
5、rmulticolumnsortsorforsortsthattakealongtimetocreate.Sorttext1.Selectacolumnofalphanumericdatainarangeofcells,ormakesurethattheactivecellisinatablecolumncontainingalphanumericdata.2.OntheHometab,intheEditinggroup,andthenclickSort&Filter.1.Dooneofthefollowing:§Tosort
6、inascendingalphanumericorder,clickSortAtoZ.§Tosortindescendingalphanumericorder,clickSortZtoA.2.Optionally,youcandoacase-sensitivesort.Howtosortbycase-sensitivity1.OntheHometab,intheEditinggroup,clickSort&Filter,andthenclickCustomSort.2.IntheSortdialogbox,clickOptio
7、ns.3.IntheSortOptionsdialogbox,selectCasesensitive.4.ClickOKtwice.Issue:Checkthatalldataisstoredastext Ifthecolumnthatyouwanttosortcontainsnumbersstoredasnumbersandnumbersstoredastext,thenyouneedtoformatthemallastext.Ifyoudonot,thenumbersstoredasnumbersaresortedbef
8、orethenumbersstoredastext.Toformatalloftheselecteddataastext,ontheHometab,intheFontgroup,clicktheFormatCellFontbutton,clicktheNumbertab,an
