Select My table has headers to turn the top row of your data into table headers. The data in this row won't be filtered.

You can also filter by more than one column. Filters are additive, which means that each additional filter is based on the current filter and further reduces the subset of data.

Filters hide extraneous data. In this manner, you can concentrate on just what you want to see. In contrast, when you sort data, the data is rearranged into some order. For more information about sorting, see Sort a list of data.

Using AutoFilter, you can create two types of filters: by a list value or by criteria. Each of these filter types is mutually exclusive for each range of cells or column table. For example, you can filter by a list of numbers, or a criteria, but not by both; you can filter by icon or by a custom filter, but not by both.

When you apply a filter to a column, the only filters available for other columns are the values visible in the currently filtered range.

Waterborne bacteria and viruses can lead to serious illnesses. Recommended by the CDC, APEC’s reverse osmosis systems effectively remove bacteria from water and eliminate harmful microorganisms, offering the highest protection for your family’s health with virus removal water filters.

APEC Water is proud to have its reverse osmosis systems WQA Gold Seal Certified—a mark of excellence in water filtration. Additionally, our Ultimate Series exclusively uses high-capacity, US-made high capacity filters to ensure the best quality drinking water for your family.

There is no definite proof, but some studies state that alkaline water lowers levels of bad (LDL) cholesterol and raises the levels of good (HDL) cholesterol, hence it helps prevent heart disease and lower

Don't select the check box if you want Excel for the web to add placeholder headers (that you can rename) above your table data.

WQA Gold Seal Certification ensures top performance, unmatched quality, long-lasting durability, and trusted safety for your water filtration system. When you choose APEC Water, you’re choosing a trusted water filter system that meets the highest standards.

With over 25 years of expertise, APEC Water is a trusted provider of clean drinking water solutions to homes worldwide. Choose from our premium Ultimate Series with US-made filters, the high-performance Essence Series, the sleek and modern Tankless Series, or our convenient plug-and-play Countertop Series. APEC is committed to delivering the best reverse osmosis water filtration systems for ultimate purity and removing harmful contaminants.

As the name suggests, reverse osmosis takes this process and reverses it, using pressure to push water through a semipermeable membrane that blocks larger particles from passing. This results in pure water on one side of the membrane, with almost all contaminants left behind on the other.

Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want displayed. After you filter data, you can copy, find, edit, format, chart, and print the subset of filtered data without rearranging or moving it.

When you apply a filter to a column, the only filters available for other columns are the values visible in the currently filtered range.

Note: When you use the Find dialog box to search filtered data, only the data that is displayed is searched; data that is not displayed is not searched. To search all the data, clear all filters.

PFAS, also called "forever chemicals", are a growing concern in water contamination. APEC Water’s carbon and reverse osmosis filtration systems can remove up to 99.99% of many harmful contaminants, including PFAS, ensuring PFAS-free drinking water and protecting your family’s health.

Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.

Enjoy unlimited fresh, clean, and great-tasting water directly from your kitchen tap—perfect for cooking, coffee, tea, and ice. APEC Water’s advanced reverse osmosis systems provide 99% contaminant-free water for a healthier lifestyle. Built for durability, our products offer reliable, long-lasting performance, making them the best reverse osmosis system for home use.

2. Reverse OsmosisNext, high-pressure pumps force the water through a semipermeable membrane. The membrane allows pure water to pass through while filtering out particles like salts, minerals, metals, and most bacteria and viruses.When the process is complete, one side of the membrane will have pure water, and the other side will have leftover water with a higher concentration of contaminants. This unfiltered water is released down your drain.After this step, some systems may use additional specialty filters to pick up any remaining contaminants or a remineralizing filter to add back healthyminerals.3. StorageOnce the water has been completely filtered, a typical RO system with a storage tank will collect the water. Then, anytime you turn on the faucet for filtered water, you’ll have a supply ready for your use—no need to wait for water to go through the filtration process.

When you filter data, only the data that meets your criteria appears. The data that doesn't meet that criteria is hidden. After you filter data, you can copy, find, edit, format, chart, and print the subset of filtered data.

We have TDS meter available for purchase. It is a battery-powered simple testing device that provides the TDS reading with a digital display.

Filters are additive. This means that each additional filter is based on the current filter and further reduces the subset of data. You can make complex filters by filtering on more than one value, more than one format, or more than one criteria. For example, you can filter on all numbers greater than 5 that are also below average. But some filters (top and bottom ten, above and below average) are based on the original range of cells. For example, when you filter the top ten values, you'll see the top ten values of the whole list, not the top ten values of the subset of the last filter.

When you hover over the heading of a column with filtering enabled but not applied, a screen tip displays "(Showing All)".

You deserve to have clean water for your home. You don’t always have control over what’s included in your tap water, but with an RO system, you’ll have the peace of mind that your water is as pure as it can be.Ready to enjoy filtered, clean water from home? Shop our reverse osmosis water filtration systems!

For best results, do not mix data types, such as text and number, or number and date in the same column, because only one type of filter command is available for each column. If there is a mix of data types, the command that is displayed is the data type that occurs the most. For example, if the column contains three values stored as number and four as text, the Text Filters command is displayed .

In a range of cells or a table column, click a cell that contains the cell color, font color, or icon that you want to filter by.

Your tap water, though deemed drinkable by local processing facilities, is likely not free from impurities. A reverse osmosis water filter system removes unwanted inclusions like dirt, bacteria, salts, and minerals from your home water source so your water is cleaner, healthier, and better tasting.

Osmosis is the natural tendency of water molecules to move through a semipermeable membrane in a way that results in an equal concentration of any substances dissolved in the water (such as salts or ions) on both sides of the membrane.

You can either apply a general Filter option or a custom filter specific to the data type. For example, when filtering numbers, you’ll see Number Filters, for dates you'll see Date Filters, and for text you'll see Text Filters. The general filter option lets you select the data you want to see from a list of existing data like this:

There are a few different types of reverse osmosis systems that requires different levels of installation. Most people are able to install the undersink RO systems following the instruction manual. They do require drilling to install the faucet and drain saddle.

When you apply a filter to a column, the only filters available for other columns are the values visible in the currently filtered range.

You can quickly filter data based on visual criteria, such as font color, cell color, or icon sets. And you can filter whether you have formatted cells, applied cell styles, or used conditional formatting.

You can filter by more than one column. When you apply a filter to a column, the only filters available for other columns are the values visible in the currently filtered range.

Chlorine is commonly used to disinfect city water, but overexposure can cause skin irritation, bleach-like odors, and other unwanted effects. Our premium activated carbon filters, featured in APEC water filtration systems, effectively remove chlorine from tap water to deliver cleaner, better-tasting water.

An RO system connects to your tap water line and uses a sophisticated process to purify the water. This process can be broken down into three key steps.1. Pre-FiltrationFirst, water enters the system and passes through a series of filters designed to remove larger particles from the water. They remove substances like:

Mineralized/Alkaline water is slightly less acidic than regular drinking water. A reverse osmosis water filtration system adds alkaline minerals at its last stage after the water is filtered through an RO membrane.

An RO system can last up to 10 years if maintained properly. However, the filters will need to be changed according to the instructions that come with your system (usually every year).

APEC offers RO systems in all shapes and sizes to suit different needs. Here are the three main types of RO systems you can choosefrom.1. Tankless RO SystemsTankless RO systems are among the most convenient because they’re small enough to fit almost anywhere. They don’t have a water reservoir, so they’re compact and visually pleasing. However, they need a 110 V outlet, as they operate with electricity.These systems are built for everyday consumers with an extremely easy filter-changing process. You can replace a used filter in just a fewseconds—just twist and pull to remove, then push on the new filter.2. Traditional RO SystemsA traditional RO system has a tank that holds 4 gallons of water, so the water dispenses faster than from a tankless system. It also ensures you always have clean water available, even if your water supply is temporarily shut off. It does, however, require more space than other options.If you feel intimidated by this system, don’t be. Even though it's bigger than a tankless system, it actually has a simpler configuration. You can clearly see all parts of the system, making it easy to identify problems.3. Countertop RO SystemsA countertop RO system is a perfect option for renters and small spaces. It takes up very little space and is easy to install and maintain.The system operates with electricity and has a water reservoir you fill instead of connecting to your tap water supply. It can also dispense hot water thanks to preset and custom temperature settings.

Hardly any water on this planet can be considered completely “pure.” Even water found in the heart of a glacier or a mountain spring will have salts or minerals picked up from the earth. However, RO filtration can remove up to 99% of contaminants from water, making it the purest water you can get inside your home.

Note: When you use Find to search filtered data, only the data that is displayed is searched; data that is not displayed is not searched. To search all the data, clear all filters.

Instead of filtering, you can use conditional formatting to make the top or bottom numbers stand out clearly in your data.

When you hover over the heading of a filtered column, a screen tip displays the filter applied to that column, such as "Equals a red cell color" or "Larger than 150".

In Excel, you can create three kinds of filters: by values, by a format, or by criteria. But each of these filter types is mutually exclusive. For example, you can filter by cell color or by a list of numbers, but not by both. You can filter by icon or by a custom filter, but not by both.

While distillation and reverse osmosis systems produce water cleaner than you would normally get out of your tap, the treatment processes are completely different.To create distilled water, the water is boiled and evaporated, leaving dissolved solids behind. The vapor is then condensed, and the clean water is collected in another container.RO filtration uses pumps and a semipermeable membrane to produce clean water.While you can find both distilled water and RO-filtered water in stores and at home, RO water filtration systems are much more practical and common.