Here are some simple tips to search for specific data in SecureSheet. You may enter search parameters in the Search box, then click Search to see your results. 

Examples using Search to return specific rows or values:

  • Enter 123 in the search box. All rows where 123 is found will be returned.
  • Enter A=123 in the search box. SecureSheet looks in column A for the value 123, so you can limit the rows by value in a column. This can be an alphanumeric string.
  • Enter A=123,456,987. SecureSheet looks in column A for the EXACT values of 123 or 456 or 987 (which may be helpful if searching Employee IDs, for example). This cannot be an alphanumeric string.
  • Enter ROWS(5,10,3000). This will return rows 5, 10, and 3000.
  • Enter ROWS(55-102). This will return rows 55 through 102.
  • Enter CHARACTERS in the search box, where CHARACTERS is the alpha or alphanumeric string that you are looking for specifically. SecureSheet will return all instances of where it finds this string in any column in the SecureSheet (e.g., awonder).