Excel Add-In Filters

<< Click to Display Table of Contents >>

SmartConnect 2017

Excel Add-In Filters

Data returned to Excel via the Get Data option may be filtered using the functionality below.

 

1.Select a column header and select the value(s) that should be included in the filter.

SmartConnect_Excel2013_Filter1

 

2.Select a column header and select custom, enter the required filter information.

SmartConnect_Excel2013_Filter2

 

3.Select the Edit Filter option in the grid footer, and enter the required selection.

SmartConnect_Excel2013_Filter3

 

4.Filter details may be viewed in the grid footer and may be turned off by de-selecting the checkbox in the grid footer.

SmartConnect_Excel2013_Filter4