British Bryological Society

1896 - 2021

SEARCH FOR SINGLE WORD OR A SHORT PHRASE IN THE ALLREFS INDEX

Method 1: A simple Control-F and entering the search term, e.g.Blockeel, and clicking Find All will show all found citations. However it is not easy to copy citations to Notepad or Word using this procedure.

Method 2 (recommended)

1. in the top left cell of the downloaded Excel file (cell A1 has BBS SEARCH ALLREFS in it and is colour filled), click on the down arrow at right hand end of cell A1

2. Select and click "Text Filters" to reveal the Autofilter box, wait until you can see "Contains" from the new dropdown menu. Click on Contains.

3 In the box to right of Contains enter the text you wish to search for, e.g. Blockeel and then click OK.

4. A list of citations containing Blockeel is displayed. Select the citation(s) of interest and copy into a text editor programme such as Windows Notepad or word processor such as Word.

5. To make another search go to (1.) as above or press Control-Z then Control-Home to again display the entire BBS Cumulative Index Excel database.

Do not try to save the file when you finish.

SEARCH FOR TWO SEPARATE WORDS OR SHORT PHRASES IN THE ALLREFS INDEX

If you wish, you can search for a second term that occurs in the same citations as say Blockeel.

1. In the top left cell of the downloaded Excel file (cell A1 has BBS SEARCH ALLREFS in it and is colour filled), click on the down arrow at right hand end of cell A1.

2. Select and click "Text Filters" to reveal the Autofilter box, wait until you can see "Contains" from the new dropdown menu. Click on Contains.

3. In the box to right of Contains enter the text of first term you wish to search for, e.g. Blockeel, make sure the "and" button is selected and click the empty box below the "and" button and select "Contains" from dropdown menu. This time enter the second term, e.g. Lara. Click OK

4 A list of those citations containing both Blockeel and Lara is displayed. Select the citation(s) of interest and copy them into a text editor programme such as Windows Notepad or word processor such as Word.

5. To make another search go to (1.) as above or press Control-Z then Control-Home to again display the entire BBS Cumulative Index Excel database.

Do not try to save the file when you finish.


Return to Allrefs Download Page

Return to Cumulative Index Home Page