How to search in a spreadsheet

BillW
3StarLounger
Posts: 208
Joined: 24 Mar 2010, 15:22

How to search in a spreadsheet

Post by BillW »

how do I search a spreadsheet (Libre Office Calc in my case) to see if a particular item is listed?

Thanks,
BillW

User avatar
HansV
Administrator
Posts: 78481
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to search in a spreadsheet

Post by HansV »

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.
Best wishes,
Hans

BillW
3StarLounger
Posts: 208
Joined: 24 Mar 2010, 15:22

Re: How to search in a spreadsheet

Post by BillW »

Thanks Hans, that has me all set!
BillW