Excel: Sorting a table of names by surname


Share this

How to sort data in Microsoft Excel

1. Lets say we have a list of names in an Excel Spreadsheet
2. Select the range that you need to sort, if you have more columns then select all columns
3. Select the Data Tab and click on sort, select the sort by field and select the column that you want to sort by (in this case column B (surname) then click OK
4. Your list will now be sorted by Surname
Optional: Now you may want to paste the table into Microsoft Word. Copy the range in Microsoft Excel and open Microsoft Word. Right click on the Word document and select paste – use destination styles and the list will be inserted into your document as a table..

Share this
Article Rating:
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...