Additional formatting options in Google Sheets

In the post How to automate tasks on Google Sheet with Macro, Google has provided an overview of several ways to make Google Sheets more useful for businesses. Here are some details that G Suite admins should know.

Record Macros in Sheets

To help save your team time completing repetitive tasks, you can record macros in Sheet. When you record a macro, the macro is saved as an App Script – Apps script that you can run in the Cloud whenever you need to perform a task. You can also edit and change the script, or import the ready-made App Script as a new macro. See the post above for more details or Help Center for specific steps.

Group rows and columns in a spreadsheet

There is a new option to group rows or columns in a Sheet. This makes it easy to collapse or expand multiple rows and columns at once to customize your view. You can go to the Help Center to know more about How to manage rows, columns, and cells.

Add checkboxes to a list on Sheets

You can turn a list of items into a checklist with the new checkbox feature. You can go to the Help Center to know how to add and use checkboxes

Improved Pivot Table by Date

Google makes it easier to work in Pivot tables by categorizing data by time and date: including hours, days, months, quarters, years, and more. See the Help Center to find out how to add and use pivot table.

Print spreadsheets better

Google is adding new features to make it easier to print spreadsheets. Specifically, you can select the paper size and customize the page break settings. This makes it easy to get the right content from the spreadsheet on the printed page. Visit the Help Center to learn more about how to print from Google Sheets.

Also, you can see more about how to limit editing permission in Google Sheets here.

Updated: Gimasys