Thursday, November 22, 2012

Sort values in Excel


It’s easy to sort a table in Excel, but you have to be careful! There are two important rules:

1. No empty cells in the table
2. Select only one cell or the entire table before you click on Sort

Wrong (only the selected names will be sorted):




Right (all the names will be sorted, and Excel excludes the heading and the total automatically):



















The result:

No comments:

Post a Comment