Overview

You can search for data in any of the cells in the workbook by specifying the sheet and the string of data for which to search. You also have several searching options you can choose from.

  Search for:    
  
 IDLastNameFirstNamePhoneAddressCityStateZipContract
1172-32-1176WhiteJohnson408 496-722310932 Bigge Rd.Menlo ParkCA94025true
2213-46-8915GreenMarjorie415 986-7020309 63rd St. #411OaklandCA94618true
3238-95-7766CarsonCheryl415 548-7723589 Darwin Ln.BerkeleyCA94705true
4267-41-2394O'LearyMichael408 286-242822 Cleveland Av. #14San JoseCA95128true
5274-80-9391StraightDean415 834-29195420 College Av.OaklandCA94609true
6341-22-1782SmithMeander913 843-046210 Mississippi Dr.LawrenceKS66044false
7409-56-7008BennetAbraham415 658-99326223 Bateman St.BerkeleyCA94705true
8427-17-2319DullAnn415 836-71283410 Blonde St.Palo AltoCA94301true
9472-27-2349GringlesbyBurt707 938-6445PO Box 792CoveloCA95428true
10486-29-1786LocksleyCharlene415 585-462018 Broadway Av.San FranciscoCA94130true
   

You can programmatically search the cell text, headers, notes, or tags. You can also specify the starting row and column and the ending row and column.

Documentation