Quick Tips
Searching & Filtering Within the Scholarship MASTER Sheet
The Scholarship MASTER
Click here to open the MASTER in a new window.
TIPS & TRICKS
After opening the Scholarship MASTER (via the button above), you can filter and/or search (in "view only mode") for specific keywords. Awesouuumesauuuce!!
I hope you find this to be a useful tool! If you have any questions, you are welcome to contact me [Ms. Keltner] in Guidance (816/986-3051 or jessica.keltner@lsr7.net).
To Search for Keywords
- Highlight the entire sheet by clicking on the blank cell at the top left-hand corner of the sheet
- Press the 'Ctrl' and 'F' key down at the same time
- Type in any part/word that you feel will yield scholarships you are interested in: "athle", MU, Missouri, Engineering, "econ", etc.
To Filter by Column
To filter the spreadsheet down so you only have to go through scholarships that match your criteria/requirements:
- Highlight the entire sheet by clicking on the blank cell at the top left-hand corner of the sheet
- Navigate to the right, along the tool bar, and click on the drop-down arrow next to the "funnel" (this is the filter button)
- Choose the first option: "create new filter view"
- Click on the tiny drop-down next to the column heading you want to sort we'll use GPA, for example)
- When the box pops up, click "clear"
- Re-check whichever GPA results are appropriate (if you have a 3.7 you might re-check all the boxes including and below "3.7")
- Click OK
J. Keltner, College & Scholarship Coordinator @ LSN
Email: Jessica.Keltner@lsr7.net
Website: lsnhs.lsr7.org
Location: Guidance Office
Phone: 816-986-3051
Twitter: @LSNGuidance