Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Filter Data In Workbook In Browser. 1Click on the icon in the browsers toolbar. To sort text in ascending order click Sort Ascending.
To enter a range table or sheet manually select Custom Input. On the Home tab in the Editing group click Sort Filter and then click Clear to clear the filter. Click the arrow in the column header.
Place the cursor where you want to insert a field parameter or filter value.
The Web-based viewer does not save parameter values with the workbook. To see the results click Apply at the bottom of the Parameters pane. For example include the daterange filter in a WHERE clause. 2Click on the icon in the browsers toolbar.