How to sum by category in Google Sheets

Sometimes, we need to sum by a category in Google Sheets.

We can use SUMIF function, SUMIFS function and UNIQUE function for this. 

2 Methods to sum by category in Google Sheets 

  • Summing according to a given range using SUMIF
  • Summing according to a given range using UNIQUE and SUMIF

Read more

How to count characters in Google Sheets

Unlike Google Docs, Google Sheets doesn’t have an in-built word count option. To count characters in Google Sheets, you have to improvise.

The LEN function is used for counting characters in spreadsheets. This function is more powerful than the in-built word count function in Google Docs. You can specify what you want to count and also specify the conditions.

4 ways to count characters in Google Sheets

  • Count all the characters in a cell
  • Count all the characters in a column
  • Count the characters and ignore spaces
  • Count specific characters

Read more

How to hide columns in Google Sheets

Hiding unused columns in spreadsheets helps you focus as you work. You may have to show your spreadsheet to an audience. Hiding unused columns will also help your audience focus while you are presenting the spreadsheet.

There are two methods you can use to hide rows and columns. 

  • Using Mouse and keyboard
  • Using Keyboard shortcuts

Read more

How to insert SuperScript and Subscript In Google Sheets

Google Sheets doesn’t have a direct option to insert a superscript or subscript. It might be pretty frustrating because this is pretty easy on Google Docs. Fortunately, there are a few ways you can try to insert superscripts and subscripts in your sheet.

4 methods to insert superscript and subscript in Google Sheets:

  • Using the CHAR function
  • Using Unicode symbols
  • Using third-party websites
  • Using Google Docs

Read more

How to Change Cell Padding in Google Sheets

Cell padding helps your spreadsheet become more readable. Also, it gives viewers more whitespace, which helps them concentrate.

Unlike Microsoft Excel, Google Sheets doesn’t allow you to pad cells. However, you can adjust the vertical and horizontal spacing of the cells in your spreadsheet. This workaround will give you similar results.

The following methods will help you achieve cell padding with Google Sheets.

2 types of cell padding in Google Sheets

  • Vertical Padding
  • Horizontal Padding

Read more

How to Insert Special Characters in Google Sheets

Unfortunately, there are no direct ways to insert special characters in Google Sheets. There are a few workaround methods that you can use instead. 

3 methods to insert special characters in Google Sheets

  • Copy special characters from Google Docs
  • Copy special characters from the internet
  • Copy special characters from the Windows Character Map

Read more

How to Divide Numbers in Google Sheets

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