Ask Your Question

Search highlighted section in calc? [closed]

asked 2017-09-17 05:00:10 +0200

appreciatethehelp gravatar image

Hello. I would like to be able to search a specified section of a spreadsheet in calc, however when I highlight the section, enter the word/number I am searching for in the search bar, then hit enter, the search ignores the part I have selected and simply shows me the first instance of that word/number (from left to right/top to bottom, like reading a book).

How can I get around this? Thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-09-17 11:05:38.589119

1 Answer

Sort by » oldest newest most voted

answered 2017-09-17 05:56:19 +0200

librebel gravatar image

Hello @appreciatethehelp,

instead of selecting "Edit : Find..." ( CTRL+F ) and typing your search term into the Search Bar,

  1. select the menu "Edit : Find & Replace..." ( CTRL+H);
  2. in the dialog that pops up, enter your search term into the "Find" field;
  3. Click on the small arrow next to "Other Options";
  4. Check the checkbox "Current selection only";
  5. in the dropdown listbox called "Search in:", select the item "Values";
  6. Then click on the "Find All" button.
edit flag offensive delete link more


Thank you kindly!

appreciatethehelp gravatar imageappreciatethehelp ( 2017-09-17 11:05:19 +0200 )edit

Question Tools

1 follower


Asked: 2017-09-17 05:00:10 +0200

Seen: 17 times

Last updated: Sep 17