how do I search a spreadsheet (Libre Office Calc in my case) to see if a particular item is listed?
Thanks,
BillW
How to search in a spreadsheet
-
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to search in a spreadsheet
If you know in which range you want to search, select it. Otherwise, select any single cell.
Select Edit > Find... or press Ctrl+F to activate the Find dialog.
A search box will appear at the bottom of the window, between the sheet tabs and the status bar.
Enter the word or phrase you want to find.
To find the first occurrence, click the down arrow or up arrow button to the right of the search box. Keep on clicking to find more occurrences (if any).
To pop up a list of all occurrences, click Find All.
Select Edit > Find... or press Ctrl+F to activate the Find dialog.
A search box will appear at the bottom of the window, between the sheet tabs and the status bar.
Enter the word or phrase you want to find.
To find the first occurrence, click the down arrow or up arrow button to the right of the search box. Keep on clicking to find more occurrences (if any).
To pop up a list of all occurrences, click Find All.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 208
- Joined: 24 Mar 2010, 15:22
Re: How to search in a spreadsheet
Thanks Hans, that has me all set!
BillW
BillW