Spreadsheets cannot be edited once they're added to Merit. Make any necessary changes to your spreadsheet prior to uploading it.
When preparing your achievement, you may often find yourself needing to group similar students together in your spreadsheet. This page includes instructions for sorting a spreadsheet of students.
Instructions
In this example, we have a mixed spreadsheet of students, including multiple students from Albany:
For this tutorial, we will sort our spreadsheet according to students' hometowns and then their last names. To do this, highlight the entire spreadsheet by clicking on the box in the top left corner:
Once the entire spreadsheet is selected, go to the Data tab and choose the Sort option:
This will open up a dialog box where you can choose a column from your spreadsheet (Hometowns) and sort the column accordingly:
Note: Always make sure the "My list has headers" box is checked to prevent mixing column titles into the spreadsheet.
At this point, our list is ready to be sorted by hometowns, but we can add another column by clicking the + icon. This will let you sort by a secondary column (Last Names):
Click OK to sort the spreadsheet according to the chosen order (Hometowns then Last Names):
Note: The instructions and images on this page may differ slightly depending on your operating system and version of Excel.