How to Divide Numbers in Google Sheets

You can use Google Sheets for a variety of calculations. Now, a lot of these would include divisions and this is what we are covering today. Here are the various ways you can divide numbers on Google Sheets. You can divide individual cells and entire columns.

4 methods of dividing numbers in Google Sheets 

  • Dividing numbers in cells using DIVIDE function
  • Dividing numbers in cells using divide operator
  • Dividing entire columns 
  • Dividing without a remainder 

Read more

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 change date format in Google Sheets

When you’re working with dates in your Google Sheet, you might not like the default format. You may want to change it to a different format for your convenience. The good thing is that you have several ways to do that in Google Sheets.

3 methods to change the date format in Google Sheets

  • Using the default Google Sheet formats
  • Using custom date formats
  • Using a query function

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 your numbers. This can be useful at times but not at all times. If you’re wondering how to make Google Sheets stop rounding numbers, you’re at the right place. 

2 ways to make Google Sheets stop rounding numbers

  • By increasing the decimal places
  • Using the TRUNC function

Read more

How to Zoom in and Out in Google Sheets

Google Sheets are a helpful free option for people to work on different datasets. Zooming in and out on Google sheets proves to be handy. We are covering two ways to do this with a handy shortcut as well. 

3 Methods of Zooming in and out of Google Sheets

  • Using the tool bar options. 
  • Using the view options.
  • Using key shortcuts. 
  • Zoom in and out of Google Sheets on mobile.

Read more

How to sort by date in Google Sheets

When you’re working with dates in Google Sheets, it can come in handy if you know how to sort by dates. This would make working on Google Sheets much easier. A date is just a number in Google Sheets and it sorts the date data using that number. This means it’s important that your date is in the correct format.

3 methods to sort by date in Google Sheets

  • Using a formula
  • Using the Sort range option
  • Using the Sort sheet option

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