HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
Filters can be applied to sort and hide data. It makes data analysis easier
Filters can be applied to sort and hide data. It makes data analysis easier.
Note: Filter is similar to formatting a table, but it can be applied and deactivated.
The menu is accessed in the default Ribbon view or in the Data section in the navigation bar.
Filters are applied by selecting a range and clicking the Filter command.
It is important to have a row of headers when applying filters. Having headers is useful to make the data understandable.
Note: Filters are applied to the top row in a range.
Like in the example below, the dedicated row is row 1.
Let's apply filters to the data set, step by step.
Select range A1:E1
Click the Sort & Filter menu
Click the Filter command
New buttons have been added to the cells in the top row. This indicates that the Filter was successfully applied. The buttons can be clicked to access the different Sort & Filter options.
Lets delete row 1 (the header row) and apply filters to the new row 1, to see what happens.
The filter is applied and has replaced the header row. It is important to dedicate a header row for the filter.
The filter options allow for sorting and filtering.
Applying filter keeps the relationship between the columns while sorting and filtering.
Clicking the options button opens the menu.
Ranges can be sorted and the relationship between the columns is kept.
You can read more about Sorting in a previous chapter.
Filters can be applied to hide and sort data.
This is helpful for analysis, to select the data that you want to see or not.
Example Filter
Use the filter option to filter on Pokemon that is Type 1, Bug.
Step by step
Click the drop down menu on C1 () and choose the Filter option. This is the Column which holds the Type 1 data.
Note: "Items" are the different categories in that column; Grass, Fire, Water and so on.
All items are checked by default. The checked items are the ones that are shown. Uncheck to hide.
Uncheck all items, except Bug, which is the type that we want to show.
Click OK
Note: The unchecked rows are hidden, not deleted.
This is explained by looking at the row numbers. The numbers are jumping from 1 to 11 and 16 to 22. The rows in between are hidden.
Note: Checking the items will have the rows shown again.
Use the filter option to filter the Pokemons which have Type 1, Bug and Type 2, Poison.
function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Range copied to clipboard.\nIt can now be pasted into the Excel spreadsheet.') }) .catch((error) => { alert(`Copy failed! ${error}`) }) }