Switch on the data filter in EXCEL
Click “Review” in the ribbon menu at the top of the screen.
Click “Unprotect” and enter the password you used to protect the data, or download the file again.
In column E, the dark grey vertical line, type several spaces in the top block/cell, so the data filter will work properly.
Click “Data” in the ribbon menu at the top of the screen.
Click “Filter”, and a data filter should appear in the top row, for every column.
Use the data filter to search
Go to the TOP of the spreadsheet, to Row 1, where the column headings are.
Find column C, “ISSN”, and click the small down arrow, which opens up a menu box.
Find the “Text filters” option. Type the journal ISSN of the journal, or part of it, into the box just below it. Press ENTER.
Wait for EXCEL to complete “searching” and display a box of search results.
Searching for a journal series, example “Nature” or “Frontiers in”
If EXCEL found a LOT of journals, and is displaying a long list in the search results box:
- Click OFF the very top tick box “Select all search results”.
- Scroll down in the white search results box till you find the journal you want.
- Click ON the tick box for that journal.
- Only the journal you want will be displayed.
If you can’t find the journal
If the journal does not appear on the list, that means it is not accredited for 2023.
Doing another search
To do the next search, click these options on the ribbon menu at the very top of the screen: Data > Clear.
Videos
To see videos on how this works, click here