1. Select the range of data you want to filter.
2. On the ribbon, select Data, then click the Funnel icon to turn on filters.
3. In the column with customers, click the down arrow in the first filter row.
4. Uncheck all but the one you want to filter on.and click OK
5. In the column with order numbers, click the down arrow in the first filter row.
6. Uncheck all but the one you want to filter on and click OK
7. In the column with the dates, click the down arrow in the first filter row
8. Uncheck all but the one you want to filter on and click OK.
you should now have a filtered list of only items on the original order.
Bookmarks