What is targeting in Google Sheets and how do I use it?
Segmentation is one of the best spreadsheet tools, an excellent solution in many ways to Google Sheets filters, you should know how to apply
Not only can you use it in your documents, and fully customize it, but it will still be there when other people access the files you set up for them.
In addition to everything we've already shown you about Microsoft and its spreadsheets, those of Excel, we can't lose sight of the fact that the folks at Google have their own office suite, with spreadsheets. As you may be among those who use it, today we show you in detail what partitioning is in Sheets and how to use it to make your spreadsheets look more professional.
The point is, if you've been a Google Sheets user for several months, you might have noticed the "Slicer" feature. We are talking about a function that allows you to filter tables, graphs or pivot tables in your spreadsheet. We can also define it by its name in Spanish, which is nothing more than a hash.
But what is a divider in Google Sheets?
As mentioned, this solution can be used as a hash, and what it intends to filter the data. So, you may be wondering how they are different or better than the filters available in Google Sheets.
The answer in this sense is quite simple, and that is that it will allow you to manipulate the data in a jiffy, with the advantage of being able to save the hash for further use, which is impossible with common filters.
With Slicer, you can set a default filter, so that anyone who has access to the spreadsheet will see it there, applied, when they open it. If you dedicate the board to your staff, they will appreciate it.
How to implement the hash tool in Google Sheets?
Now that you know what the purposes of this hash tool are, let's see how to use it:
First, select the schema or table you want to apply the hash to, from Data, Filter Data
Once you get to the previous menu, go to Slicer in Google Sheets and place the Slicer where you want it in the document
With Slicer already added, select or open a filter column in the displayed sidebar
At this point, you should see the column labels for the column data drop down.
When selected, you will see that it is displayed inside Slicer, filtering according to the desired property
By accepting, you can apply all the filters you want, and you will see their reflection in the graph or table
You'll also be able to see the amount of items filtered within the hash itself, of course
As you go, you can undo recent filters if you think they don't provide more
How to modify or customize the slicer?
If using Slicer isn't complicated at all, it's also not difficult to modify or customize the way it appears in the document. You can import data from another spreadsheet, modify the dataset, etc., from the three menu points, which are always in the upper-right part of the screen, by going to the Edit Hash section.
There the Slicer or Hash sidebar will reopen, with the Data and Customize tabs, using the former to set the data range, or the Column dropdown for other different filters. You can modify the title, font style, size, format, color, and even background color.
Likewise, actions you may not have known and taken into account will appear, so take advantage. We can cite copy targeting or removing it, setting filters as default, etc.
In the same way, you can add more than one partition to the same data set, which is especially practical. You will be able to configure multiple filters for multiple columns of data for a graph or table, making it more understandable.