Skip to main content

Information Filter

Zhongshan College of UESTC
This app provides the function of retrieving information you want to display in Excel 2013

Before you begin, a sample Excel document can be downloaded from https://zscoffice1.sinaapp.com/Information%20Filter/sample

%20data.xls.

The sample file we provided illustrates a table of products. Product's attributes are stored in columns wise. For example, Col A is ID of products, Col B is name, and Col C is price. Each row stands for a single product.

This app will focus on the information you interest in. For example, you want to inquire the product name, price and manufacturing date only.

-Click "Start to Select" button

-Select a region you interest in. Click left-upper corner of the region first and then the right-down. For example, firstly we

choose row 1 col A, then row 20 col I.

-Select the type to display. You can choose from row or col. In this example, we choose Col to show all names of the products.

-Input a number in each edit box below radio with respect to the region you selected. For example, 1 indicates the col of product

name, 2 indicates the col of product price, 8 indicates the col of manufacturing date.

-Select any cell in Col A (do not exceed the region you selected). For example, Col A Row 1 is selected, the name, price and

manufacturing date about product ID(6902223114059) will display in taskpane.

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474839947/Product_42949675136/Asset_eb060529-ccb2-4aea-9e49-8f964149abaa/1.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474839947/Product_42949675136/Asset_eb060529-ccb2-4aea-9e49-8f964149abaa/1.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474839947/Product_42949675136/Asset_a360c9a7-7c74-457d-bb2e-f28475f3f0ca/2.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474839947/Product_42949675136/Asset_f3c7d4de-aa40-4aa1-9ada-82e5f0ad97a9/3.jpg