Managing Waste Streams Planning Tool - Spreadsheet

As an alternative to using the online tool, you can download the Spreadsheet Version: Managing and Transforming Waste Streams (xls) (179 KB, July 2015) and use it on your computer.

To Select Multiple Terms in Dropdown Menus

• In the Header of a particular column, click on the small box with an Arrow in it to display the drop down menu.
• Once in the drop down menu, below the Search feature you will see a list of terms used in at least one row in the column, preceded by check boxes.
• Uncheck the box(es) for a term(s) in rows that you do not want to be displayed in the table.
• Alternatively, uncheck the “Select All” box and re-check boxes for terms in rows that you would like to display. 

To Hide Rows or Columns

• Select a cell in the row or column you would like to hide
• Click on “Format” 
• Under “Visibility”, click on the option “Hide Rows” or “Hide Columns” 
• To undo this change, click on “Unhide Rows” or “Unhide Columns”