Filter by Format Icon

Filter by Format

Filter by Format is a simple tool allowing you to filter data within spreadsheet

Filter by FormatOverview

Filter by Format is a simple tool allowing you to filter data within a Spreadsheet based on the formatting of cells. It is both a spreadsheet productivity enhancer and a data analysis tool, useful for anyone working in Microsoft Excel where a variety of different formatting criteria is used to define and classify the data.

Filter by Format allows you to display or not display data which meets your pre-defined formatting criteria based on the selection of an example cell. It can filter by both rows and columns, hiding the row/column of cells which do or don’t meet the desired format. Filter on cell colour, font colour, font type, font size, bold and italics or a combination of these formatting criteria.

Features:

Filter your data based on rows or columns
Include or exclude the header row/column from your data
Filter based on cells matching or not matching specified formatting criteria
Filter based on cell colour, font colour, font type, font size, bold and italics or a combination of these formatting criteria.

NEW

Fixed some bugs.

Filter by FormatInformation

Version
0.7
Date
04.23.09
License
Trial
Language
English
File Size
5.60MB
Category
SubCategory
Operating Systems
Windows Vista, XP, 2000
System Requirements
No additional system requirements.
Office Excel 2007 Icon
You can get specific information about this update in Microsoft Knowledge Base.
Demo
Kutools for Excel Icon
Bring more than 120 advanced functions to Excel.
Demo
Excell Icon
Manage your data by using CSV files
Free
NodeXL Icon
NodeXL is an Excel 2007 template for viewing and analyzing network graphs.
Free
Microsoft Excel Viewer 2003 Icon
open, view, and print Excel workbooks, even if you have example excel formula.
Free
Excel Macro Processor Icon
Apply MS Excel macros to a lot of xls files at a time with this automation tool.
Trial
Bond Portfolio Spreadsheet Icon
A Comprehensive Bond Portfolio Tracking Spreadsheet
Free
XLRISK Icon
Monte Carlo simulation software that makes quantitative risk analysis intuitive.
Trial
More