Alphabetizing columns in Excel?

Question

How do sort 2 Excel columns (one with first names, the other with last names) alphabetically by last name while keeping the the two names together? Thanks!

Answer 1

if both columns are right next to each other, excel will automatically sort the 2 together.  If you want to ensure that excel keeps them together, highlight the data you wanted sorted first, then select the sort option