Google Sheets is one of the most essential tools for office workers. In this article, I am going to introduce how Grouping in Google Sheets work and also adding other useful Google Sheets features that make things convenient in your work!

Google Sheets Checkbox

You have to create and add box options manually for the projects that need to be confirmed or tracked. Now, Google Sheets have created a checkbox feature for you! You are able to make a list of to-do items that can be seen at a glance with this Google Sheets Checkbox:

Create the column in the Google Sheets

At first, you can add a column and select the range. In the range, click”Insert”and select”Check Box”. The shortcut key is”Alt+I”, then enter”X”.

Click insert then add checkbox to the Google Sheets.


It is convenient especially when you are to manage projects that need to be confirmed or approved. You can use it as a to-do list, project task management, list of customers to be contacted and etc. Hence, you can track your work at a glance at which projects have not been completed.

Checkbox added to the checklist.

How grouping in Google Sheets works?

The grouping in Google Sheets function can group the specific rows and columns in the Google Sheets, divide and fold the temporarily unnecessary columns into similar group, and expand the columns by”+”and”-“at the top.

Report data for grouping in Google Sheets.

Take the report in the above picture as an example. Suppose that the F-H column is a field for your personal work. If you don’t want it to be displayed to your superior, you can set the F-H column to the same group and fold the fields in this group. This function is very suitable for closing a wide range of columns, saving the trouble of opening single columns one by one.

Click to group selected column with grouping in Google Sheets feature.

To cancel the column grouping, you can”ungroup columns F-H”.

Click to ungroup selected column in grouping in Google Sheets feature.

How to set custom printing in Google Sheets?

In the most recent edition, Google Sheets”Print”has added more options to its own settings.

Click to print the Google Sheets.

You can customize the”Paper size”to various sizes.

Set the custom page range for Google Sheets.


In addition, the”Set Custom Page Breaks”in the blue text on the right side of the page allow you to move the blue line to adjust the printing range, so that you can print the content you want accurately and more customized.

Adjust the blue line according to required needs to print the Google Sheets.


I hope that you can fully utilize the Google Sheets’ powerful features, especially the above-mentioned functions. It can help you to speed up your works and saving a lot of trouble and time.


Related Articles:

  1. Google Sheets Dropdown List : How to create Data Validation
  2. Google Sheets Exchange Rate : 3 steps to calculate exchange rate!