Excel sheet me filter kaise lagaye

Filters are applied to rows of data in the worksheet. Apart from multiple filtering options, auto-filter criteria provide the Sort options also relevant to a given column. Here we discuss how to use filter shortcuts in Excel along with practical and go to another worksheet/workbook and paste the filtered data by pressing Ctrl+V.

When excel identifies that the column contains text data, it automatically displays the option of text filters. For excel sheet me filter kaise lagaye I need to select filter icon in region header, I have to uncheck or deselect all the regions except the north region.

It returns mobile sales data in the northern region only. Excel sheet me filter kaise lagaye with this data, I further filter in product region.

I have to just apply the filter in product column apart from region column. It returns Nokia excel sheet me filter kaise lagaye data in the north region.

For that I need to select filter icon in units sold header, I have to select number filters, excel sheet me filter kaise lagaye under that greater than an option.

Once greater than option under number filter is selected, pop up appears i.

Filter in MS Excel - How To Filtering Data in Excel - Excel Tutorial Part 14

Custom auto filter, in that under the unit sold, excel sheet me filter kaise lagaye want datasets of more than 30 units sold, so enter Click ok.

It returns mobile sales data based on the units sold.

Once the filter is applied in units sold column, Excel pinpoints you that table is filtered on a particular column by adding a funnel icon to the units sold column drop-down list button.

Date filter lets you filter dates based on any date range.

For example, you can filter on conditions such dates by day, week, month, year, quarter, or year-to-date.

In the mobile sales data, if I want a mobile sales data only on or for the date value i.

For that I need to select filter icon in date header, I have to select date filter, and under excel sheet me filter kaise lagaye equals to option. Custom AutoFilter dialog box will appear, Enter a date value manually i. It returns mobile sales data only on or for the date value i.

Excel Keyboard Shortcuts – Open Thread

Things to Remember About the Data Filter in Excel Data filter helps out to specify the required data that you want to display. A Data Filter option is Removed.

Excel data filter option can filter excel sheet me filter kaise lagaye records by multiple criteria or conditions i.

Data can be also filtered out with the help of wild characters i. Here we discuss litecoin source address lookup to Add Data Filter in Excel with excel excel sheet me filter kaise lagaye and downloadable excel templates.

• 15 Comments