How to Subset Data in Excel. Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data ...

I have a work sheet, it has 10,000 rows.2,000 of those are for the state of New York.So I add a filter, then drop down on the state column and select New York.I then have 2,000 rows displayed.I ...

This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.

This article will teach you how to transfer data from one spreadsheet to another in Microsoft Excel if your copy and paste function is not working. This article will show you three methods of how to ...

Raw data comes in a variety of forms that can lead to inconsistent record keeping. Maintaining your data in Excel increases efficiency in bookkeeping, sales records and tax preparation.

Excel Ideas helps you extract the key information from a spreadsheet, but there's currently a limited range of insights available and some data formatting may be required.

To clear a filter, click Clear in the same group. In Excel 2003, choose Filter from the Data menu, and then select AutoFilter (to clear a filter, uncheck AutoFilter).