I have a long list of numbers in a column, and would like to do a find, but have all the finds automatically highlighted so I can easily see them, without having to manipulate any of the info on the sheet. Can this be done? Thanks
try this extensions http://extensions.libreoffice.org/extension-center/alternative-dialog-find-replace-for-writer and http://extensions.libreoffice.org/extension-center/search-in-calc
You can use Edit > Find & Replace… (CTRL+H) and use Find All. This will highlight all matching cells i.e., a search for “12” will match “12”, “123”, and “312”. If you want to find and highlight only a specific number (i.e., “12” but not “123” or “312”) click the More Options button and check the Regular expression option and then search for “^12$” i.e., ^ = beginning of cell, $ = end of cell.