How to insert CheckBox in Google Sheets

Having checkboxes in your Google Sheet can come in handy when you have items to be crossed off your list. Fortunately, inserting checkboxes in Google Sheets is a straightforward process.


Using the Checkbox option

Step 1: Highlight the desired cell.

Click on the cell to insert a checkbox there. In this instance, it’s cell B2. You can see the highlighted cell’s name in the Name box at the top-right corner of your screen below the toolbar.

Read more

How to Search in Google Sheets

Have trouble tracking down what you need in the piles of data stored in Google sheets? You don’t want to scroll for minutes to find a customer name or a product name. Well, the functionalities that Google Sheets provide help pinpoint the needle in the haystack.

3 ways to search in Google Sheets

  • Search sheets using the Find option
  • Search using Find and Replace
  • Search using Conditional Formatting

Read more

How to Multiply in Google Sheets

When you’re working with numbers on your Google Sheet, knowing how to multiply them can come in handy. For instance, say you have the quantity and price of each item and you’d like to know the total cost for all the items.

4 methods to multiply in Google Sheets

  • Using the multiplication operator
  • Using the MULTIPLY function
  • Using the ARRAYFORMULA function
  • Using the SUMPRODUCT function

Read more

How to make Google Sheets Stop Rounding Numbers

If you’ve worked with numbers in Google Sheets, you would’ve noticed that it rounds off numbers by default.

However, it is also possible to configure google sheets so that it stops rounding numbers. Here are a couple of ways to do it.

2 ways to make Google Sheets stop rounding numbers

  • Using Increasing Decimal Places option in the Toolbar
  • Using the TRUNC function

Read more

How to add current date and time in Google Sheets

Adding the current date and time in your Google Sheet can be very helpful for several reasons. For instance, it can help you timestamp activities assigned or done. There are multiple ways to add the current date and time in your Google Sheet.

3 methods to add current date and time in Google Sheets

  • Using a formula
  • Using keyboard shortcuts
  • Using a script

Read more

How to calculate percentages in Google Sheets

When you’re working with data on your sheet, you might often come across numbers. It can be useful to convert them to percentages as it’s easier to visualize. Fortunately, converting numbers to percentages is easy in Google Sheets.

3 methods to calculate percentages in Google Sheets

  • Using the Format as percent icon
  • Using the Percent option from Format
  • Using the percentage formula

Read more