👤
SunnyIcecream28go
Answered

it will allow you to view specific rows in excel spreadsheet while hiding the other rows

Sagot :

Answer:

The basic Excel filter (also known as the Excel Autofilter) allows you to view specific rows in an Excel spreadsheet, while hiding the other rows. When the Excel autofilter is added to the header row of a spreadsheet, a drop-down menu appears in each cell of the header row.

Cumbamariejeango

Answer:

Use AutoFilter to filter your data

Excel for Microsoft 365 Excel 2021 More...

Use the AutoFilter feature to find, show, or hide values—in one or more columns of data. You can filter based on choices you make from a list, or search to find the data that you seek. When you filter data, entire rows will be hidden if the values in one or more columns don't meet the filtering criteria.

Follow these steps to apply an AutoFilter:

Select the data you want to filter.

Click Data > Filter.

Click the arrow Filter arrow in the column header and decide if you want to choose specific values or search.

Go Training: Other Questions