How to Transpose in Google Sheets

You might need to transpose the data of your rows and columns to a different location in the sheet. This is done to present a set of data in a better way. 

2 Methods of Transposing Data in Google Sheets:

  • Using the transpose formula
  • Using paste special

Read more

How to get Last Value in a Column in Google Sheets

There are multiple instances when you need to get the last value in a column in Google sheets. You can scroll down and look at the value but this is not a good idea when you have a huge dataset. For example, there’s a list of students in descending order of marks scored. You want to know the student who has scored the least. Let’s go over some methods to find the last value in a column. 

3 methods to get the last value in a column in Google Sheets: 

  • Using INDEX and COUNTA functions 
  • Using INDEX and MATCH functions for numerical values 
  • Using INDEX and MATCH functions for text values 

Read more

How to unhide rows in Google Sheets

You may have hidden rows in Google Sheets previously for any reason. If you want to reveal them now, you just have to unhide the rows that you have previously hidden.

4 methods of unhiding rows in Google Sheets:

  • Using the arrows
  • By selecting Unhide rows
  • By pressing Ctrl + Shift + 9
  • Unhide the rows hidden by filters.

Read more

How to sum by category in Google Sheets

Sometimes, we need to sum by a category in Google Sheets. For example, you might need to sum up points scored in all games per team in a tournament season.

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