Translator
-
How to using Advanced Filter in Kingsoft Spreadsheets 2010
26th, June, 2010. From KSOffice Team
Automatic Filter and Advanced Filter are the shortcuts to search and process the data in the table. What Advance Filter different from Automatic Filter is handling the complicated data. It’s not able to display the drop-down list of a column, but types the filtering criteria in a separate criteria range and filters the data that meet multiple groups of criteria at the same time. For the operation step, please refer to the following part: You can do as below:
1>Open or create a sheet in Kingsoft Spreadsheets.
2>Type the filtering criteria in the blank cells apart from the list range.
3> Following the picture as:
4>Click Filteron the Datamenu and then point to Advanced Filter.
5>In the popup Advanced Filter dialogue, make the relative settings. For instance, you can choose Filter the list, in-place or Copy to another location; if you choosed the first one, you can restore to the origianal state by clicking Filter on Data menu and then pointing to Show All.
6>Click OK. The following is the filtered result:
Tags: Filter, Kingsoft, Kingsoft Office, Kingsoft Office 2010, kingsoft spreadsheets
Related posts
Published on June 26, 2010 · Filed under: Kingsoft Office; Tagged as: Filter, Kingsoft, Kingsoft Office, Kingsoft Office 2010, kingsoft spreadsheets
