/text/shared/01/02100000.xhp Sun Microsystems, Inc. converted from old format - fpe

finding & replacing text finding; text finding; tables replacing; text replacing; cells finding; Styles styles; finding searching, see also finding Find & Replace Searches for or replaces text or formats in the current document.

Search For Enter the text that you want to search for, or select a previous search from the list. Search options are listed in the Options area of the dialog Replace With Enter the replacement text, or select a recent replacement text or style from the list. Replacement options are listed in the Options area of the dialog. Options Entire Cells Whole words only Searches for cells with contents that are identical to the characters criteria are found. If the search term is only part of the cell content, the cell is not found. Searches for whole words that are are identical to the search text. Backwards Search starts at the current cursor position and goes backwards to the beginning of the file. Regular expressions Allows you to use wildcards in your search. Match case case-sensitive search Distinguishes between uppercase and lowercase characters. finding; selections Current selection only Searches only the selected cells. Searches only the selected text. Search for Styles Searches for the style that you specify. Select this checkbox, and then select a style from the Search for list. To specify a replacement style, select a style from the Replace with list. Match character width (only if Asian languages are enabled) Distinguishes between half-width and full-width character forms. Sounds like (Japanese) (only if Asian languages are enabled) Lets you specify the search options for similar notation used in Japanese text. Select this checkbox, and then click the ... button to specify the search options. Sets the search options for similar notation used in Japanese text. Searching in Japanese Find All Finds and selects all instances of the text or the format that you are searching for in the document. Find Finds and selects the next occurrence of the text or format that you searching for in the document. Replace All Replaces all of the occurrences of the text or format that you want to replace. Repeat this command until all replacements on your slide have been made. Replace Replaces the selected text or format that you searched for, and then searches for the next occurrence. Attribute Format No Format Click in the Search for or the Replace with box, and then click this button to remove the search criteria based on formats. The search criteria for formatting attributes are displayed under the Search for or the Replace with box. More Extends the search options. Click this button again to hide the extended search options. Search in Formulas Searches for the characters that you specify in formulas and in fixed (not calculated) values. For example, you could look for formulas that contain 'SUM'. Values Searches for the characters that you specify in values and in the results of formulas. Notes Searches for the characters that you specify in the notes that are attached to the cells. Search direction Determines the order for searching the cells. By Rows Searches from left to right across the rows. By Columns Searches from top to bottom through the columns. Extras searching; all sheets finding; in all sheets sheets; searching all Search in all sheets Searches through all of the sheets in the current spreadsheet file. After you close the Find & Replace dialog, you can still search using the last search criteria that you entered, by pressing Shift+Command Ctrl+F.