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..