Re: [libreoffice-users] LO Calc - Find in a column

Hi :)
Thanks but that option was greyed out for me so i didn't notice it.  
Regards from 
Tom :)  





> ________________________________
> From: Suo Kunlong <suokunlong@gmail.com>
> To: users@global.libreoffice.org 
> 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: 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
-- 
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