Context English Maltese
advancedfilterdialog|AdvancedFilterDialog Advanced Filter
advancedfilterdialog|case _Case sensitive
advancedfilterdialog|copyresult Co_py results to:
advancedfilterdialog|dbarea dummy
advancedfilterdialog|dbarealabel Data range:
advancedfilterdialog|destpers _Keep filter criteria
advancedfilterdialog|edcopyarea-atkobject Copy results to:
advancedfilterdialog|extended_tip|AdvancedFilterDialog Defines an advanced filter.
advancedfilterdialog|extended_tip|cancel Closes dialog and discards all changes.
advancedfilterdialog|extended_tip|case Distinguishes between uppercase and lowercase letters when filtering the data.
advancedfilterdialog|extended_tip|copyresult Select the check box, and then select the cell range where you want to display the filter results.
advancedfilterdialog|extended_tip|destpers Select the Copy results to check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under Data - Define range as a database range.
advancedfilterdialog|extended_tip|edcopyarea Select the check box, and then select the cell range where you want to display the filter results.
advancedfilterdialog|extended_tip|edfilterarea Select the named range, or enter the cell range that contains the filter criteria that you want to use.
advancedfilterdialog|extended_tip|header Includes the column labels in the first row of a cell range.
advancedfilterdialog|extended_tip|lbcopyarea Select the check box, and then select the cell range where you want to display the filter results.
advancedfilterdialog|extended_tip|lbfilterarea Select the named range, or enter the cell range that contains the filter criteria that you want to use.
advancedfilterdialog|extended_tip|more Shows additional filter options.
advancedfilterdialog|extended_tip|ok Saves all changes and closes dialog.
advancedfilterdialog|extended_tip|rbcopyarea Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.