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


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