Managing spreadsheets can be a little tricky at times. Because of this you'll want to make sure your data is organized and easy to read. One thing you should do is sort your spreadsheet so that it's easy to find the information that's important to you.
In the spreadsheet below, you'll notice that all of the data is in random order:
We can organize it by sorting it according to any of the columns in our spreadsheet. To do this, we'll first want to highlight all of the rows we want to sort:
We can then choose the Data
option and select Sort
Next we'll be able to choose which column of information we'd like to sort our data by. For this example, we'll use the High School
column. Notice that we could select a second tier of sortable data if we'd like. For example, we could sort our spreadsheet according to the person's hometown and then their last name if we'd like. In a larger spreadsheet this would create an alphabetical list of people within each town.
will move all of the students with high schools listed to the top of our spreadsheet: