How to Lock Horizontal Rows & Alphabetize in Excel. Microsoft Excel 2010 is a complex spreadsheet program in which you can enter all kinds of data and then sort that information in a variety of ways.