2020Tag Archive

Open a new spreadsheet with a Sheet named Sheet3, then a new script. This will require a new project. Also, you can run it with an old project. Use this function to add a blue color on each empty cell selected by your mouse in the Sheet3. You can see… Continue Reading Google Apps Script – change color – part 027.

Slicers in Google Sheets are a powerful new way to filter data. Add some data into your spreadsheet and insert a Pivot Table: Data then Pivot Table. Now you can show property types of cells. At the top menu on spreadsheet, click on Data and then Slicer. This will be… Continue Reading Web – New feature on Google spreadsheet named Slicer.