You are welcome. That option is greyed when there is no selection of cells.
Kevin Suo Beijing, China. 06/07/2013 05:44 PM, Tom Davies: > Hi :) > Thanks but that option was greyed out for me so i didn't notice it. > Regards from > Tom :) > > > ------------------------------------------------------------------------ > *From:* Suo Kunlong <[email protected]> > *To:* [email protected] > *Sent:* Friday, 7 June 2013, 10:35 > *Subject:* Re: [libreoffice-users] LO Calc - Find in a column > > > 06/07/2013 05:07 PM, Ian Whitfield : > > Hi All > > > > Is it possible to get Calc to search/Find in a specific column?? > > > > I have a three column list of names, (A=First, B-Surname, C=Former > > Name), with about 3000 entries and want to get the Search function > > (CTRL-F) to look in just the specific column related to the > Search. I > > have tried to pre-select the column, (right-click), but the Search > > function still looks at all the columns. > > > > PCLOS 2013 and LO 3.6.5.2 > > > > Thanks for any help. > > > > IanW > > Pretoria RSA > > > Select a column, then "Find & Replace (CTRL+H)", and make sure the > "Current Selection Only" option is selected within "More Options". You > may also use regular expressions if you wish. > > Best Regards, > > Kevin Suo 锁琨珑 > Beijing, China > > -- > To unsubscribe e-mail to: [email protected] > <mailto:[email protected]> > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: > http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and > cannot be deleted > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
