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: users+unsubscribe@global.libreoffice.org
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