If the Match case option is checked, the Excel Find command is case-sensitive.If the Match case option is not checked (the default option), the Excel Find command is not case-sensitive.The Match case option allows a user to request that the Find command should be case-sensitive. Comments (not available on the Replace tab) - Only cell comments are searched Any other cell contents are ignored.Values (not available on the Replace tab) - If a cell contains a formula, the result of the formula will be searched (not the actual formula itself).Formulas - If a cell contains a formula, the text that makes up the formula will be searched, rather than the result of the formula.The Look in: Option allows the user to decide what is to be searched. If this option is set to 'By Columns', Excel searches down each column before continuing the search at the top of the next column, etc.If this option is set to 'By Rows', Excel searches across each row before continuing the search at the start of the next row, etc.The Excel Find Search: Option allows the user to decide the order that Excel searches through a worksheet. The Excel Find Wit hin: Option allows the user to decide whether the Find command should search in the current active worksheet only, or throughout the entire current workbook. Note that most of these options are also available in the Replace tab of the dialog box.Įach of the options is discussed below: Wit hin: Option
0 kommentar(er)
