How to Sort Data in Excel & Google Sheets Read our tutorials on sorting data in Excel and Google Sheets. Sort Data Advanced Sorting Keep Rows Together During Sort Put Things in Alphabetical Order Random Sort Reverse the Order of Data Sort a Column Alphabetically Sort and Ignore Blanks Sort by Color (Highlighted Cells) Sort by Last Name Sort By Month Sort By Number Sort Dates in Chronological Order Sort IP Addresses Sort Multiple Columns Sort Multiple Rows Horizontally Sort Subtotals Sort With a Custom List Sort Without Duplicates Undo a Sort Calculationyes Keep Variable Cell Constant Lock / Freeze Cell in Formula Copy & Pasteyes Copy Every Other Row Databaseyes Clean Up Data Create a Searchable Database Drop-Down Listyes Alphabetize a Drop Down-List Duplicatesyes Show Only Duplicates Filtersyes Apply Multiple Filters Clear All Filters Copy Filtered (Visible) Data Filter by Color Filter Merged Cells Filter Rows Hide Blank Rows Hide Rows Based on Cell Value Remove Filters Show or Hide AutoFilter Arrows Show Rows With Specific Text Use Custom AutoFilters Find & Selectyes Select Every Other Row Select Multiple Cells Forecastyes Quick Analysis Tool Format Cellsyes Make All Rows and Columns the Same Height and Width Formulasyes Custom Sort List with Formula Sort Multiple Columns with Formula Sort with SMALL & LARGE Functions Functionsyes SORT Function Examples Insert & Deleteyes Delete Blank Rows Delete Every Other Column Delete Every Other Row Insert Blank Row After Every Other Row Objectsyes Make a Combo Box Outlineyes Expand or Collapse Rows or Columns Text to Columnsyes Split a Cell into Two or More Columns VBAyes VBA Sort Array Sorting Data in Excel VBA