Filtering locations and departments in Excel

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. CSA will not include 2017 tax rates or payroll forms, so, for 2017 and beyond, you will need to process payroll in another application. We recommend Accounting CS Payroll and myPay Solutions. For more information, see the following topics.

If you have locations and/or departments set up in the Chart of Accounts mask, you can easily filter on those locations and/or departments in an Engagement CS workpaper in Microsoft Excel. This feature allows you to add multiple locations and/or departments together without having to use the Insert Multiple Formuladialog. Filtering is especially beneficial for clients for whom you prepare reports based on funds.

  1. Click the Filter button on the Engagement CS toolbar to open the Select Locations and Departments dialog.
  2. Double-click or highlight the items in the Available pane and click Select or Select all to move the items to the Selected pane.
  3. Click OK to insert the selected location and/or department in the formula.


  • You can choose to filter the list of Locations and/or Departments by selecting the appropriate items from the available drop-down lists in the Locations and/or Departments fields of the Select Locations and Departments dialog. For example, you could select All locations and/or departments or select specific items. Specific locations/departments in the Selected pane are replaced when All locations/departments are selected for the same grouping.
  • The formula bar in the Engagement CS toolbar contains the word Filter when multiple locations and/or departments are selected in the Select Locations and Departments dialog.
  • The application retains the Locations and/or Departments that an individual cell holds enabling you to edit and select which locations and/or departments you want designated for that cell at any time.
  • You can also click the Location/Department Filter button in the Insert Multiple Formulas dialog to create filtered formulas as described above.

Share This