How to filter across rows in excel

To filter data across rows in Excel: Select a data range. Go to the "Data" tab. Click the "Filter" button. Select the columns to filter on. Select Custom Filter. Set filter criteria. Click OK. View filtered data.

Steps to filter data across rows in Excel

Filtering data across rows in Excel is very useful, it can help you Find and extract specific information quickly. Here are the steps on how to filter data across rows:

1. Select the range of data you want to filter: First, select the range of cells that contains the data you want to filter.
2. Go to the Data tab: In the Excel ribbon, click the Data tab.
3. Click the "Filter" button: In the "Filter" group, click the "Filter" button. This will add a drop down arrow on each column header.
4. Select the column you want to filter: Click the title drop-down arrow of the column you want to filter.
5. Select "Custom Filter": In the menu that appears, select "Custom Filter".
6. Set filter conditions: In the Custom Filter dialog box, set the conditions you want to use to filter the data. For example, to filter data that contains specific text across rows, enter the text in the Equals to box and select Union in the Equals to drop-down list.
7. Click "OK": After setting the filter conditions, click "OK" to apply the filter.
8. View filtered data: After the filter is applied, only data that meets the filter conditions will be displayed. To view the filtered data outside of the original dataset, click the Hide Filter button in the Sort & Filter group on the Data tab.

By following these steps, you can filter data in Excel across rows to find and extract specific information.

The above is the detailed content of How to filter across rows in excel. For more information, please follow other related articles on the PHP Chinese website!