Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download


Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Advanced Filter in Microsoft Excel

BUY | Excel Tips & Tricks Start

 1) Criteria

This screen shot demonstrates how to use complex computed criteria.

You can filter your list by group automatically by selecting a category.

If you want to restore your list, just select "Show All".

A few lines of VBA codes support this automation.

If you want to filter overall top three products, use the criteria for Filter # 2.

2) Copy filtered data to a different sheet.

Filtering your filtered data to a different sheet is tricky. Excel says it can't be done. We show you how to get around the problem step-by-step.

Part 6: Other Tips

1. Delete or change names quickly without using the Define Name (Insert>Name>Define) dialog box.

  • How to rename a filled range without deleting the contents of the range.

  • How to delete the name, keeping the contents of the range.

  • How to delete both the name and the contents of the range.

  • How to delete a name for an empty named range.

2. How to assign self-adjusting sequential numbers to items in your list.

3. How to make a replica of a single regular of array formula:

4. Navigation Tips in your VBE window:

5. How to locate a VBA procedure quickly in the VBE.

More Excel Tips & Tricks

Excel Tips & Tricks Start & Find Your Excel VBA Procedure Quickly From Your Workbook Window & Alternatives to Excel Array Formulas & Sumproduct & Other Useful Regular Excel Formulas & Advanced Filter & Other Tips

BACK TO Excel Tips & Tricks Start

Excel Tips & Tricks  $19.95 Secure Payment Options Instant Buy/Download 30 Day Money Back Guarantee

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

See Also: Excel Training Index Or, All Software

Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft