Within a Google Sheet, you might have blank rows. Some of these rows could be populated with special characters that are not visible unless you click on the cell. There are multiple ways of identifying the number of cells that are not blank. Let’s go over these one by one. 

4 ways to count non-blank cells on Google Sheets 

• Counting non-blank cells using COUNTA function 
• Counting non-blank cells using COUNTIF function 
• Counting non-blank cells using the SUMPRODUCT function 
• Counting non-blank cells using Count value in the Taskbar 

Read more

4 methods to subtract in Google Sheets

• Using the subtraction formula
• Using the MINUS function
• Using the SUM and MINUS functions to subtract entire columns
• Using the SUM function and subtraction formula to subtract entire columns

Read more

When you add large amounts of data to your Google Sheet, you might have duplicates or repeated values. You might want to count the unique values, pick them out, or even find the occurrences of each unique value. 

4 methods to count and display unique values in Google Sheets

• Using COUNTUNIQUE to count the unique values
• Using UNIQUE to display the unique values
• Using Remove duplicates to display the unique values
• Using UNIQUE and COUNTIF to display the occurrences of each unique value

Read more

Google Sheets is a collaborative tool. Its collaborative nature can lead to incorrect data entry and discrepancies when multiple users use the same sheet. Drop-down lists help people enter correct data from set options. This helps to maintain the integrity of the sheet. It also helps save time by making the data entry process quick. 

Creating and Modifying drop-down lists on Google Sheets

• Creating a drop-down list using data validation
• Modifying a drop-down list using data validation
• Removing data validation 

Read more

Google Sheets don’t have a built-in password-protection feature. However, it allows you to set permissions for each member that has access to your sheet. 

Therefore, the only built-in feature to protect your sheets is by restricting access through the share settings. Members can access documents over the internet, but only those with edit access can make changes. That said, you cannot give a member edit access and hide some of the information on the sheet from that member. 

If you want to encrypt data and password protect your sheet, you can use a third-party app. Alternatively, if you want to hide a specific sheet, you can do that as well.

Methods to protect your Google Sheet

• Using a third-party tool
• Controlling access via share permissions and settings by:

1. Hiding your individual sheet
2. Hiding your individual cells

Read more

When you’re working on Google Sheets, you might sometimes need to make a copy of your sheet. You might want to copy the sheet into an existing sheet, a new sheet, or even to your current sheet. Google Sheets allows you to copy a sheet easily. 

4 methods to copy a sheet in Google Sheets

• Using the Duplicate option
• Using the Existing spreadsheet option
• Using the New spreadsheet option
• Using the Make a copy option

Read more

Sometimes you might need to add an extra row between two others in your spreadsheets. In Google Sheets, you can do it by right-clicking the row and selecting the Insert Row option found in the menu.

In some cases, however, one extra row may not be enough. You’ll need to add multiple rows to enter your data. Google Sheets has met this requirement too with many options to add multiple rows. 

5 Method To Add Multiple Rows

There are many simple methods to accomplish adding as many rows as you want. 

• Using the Insert Rows option
• Using keyboard shortcuts
• Using the Add button at the bottom
• Using F4
• Using Macros

Read more

Sometimes your Google Sheet might contain a lot of information. You may want to group some columns and hide the information in them to make the sheet look sharp and tidy. This is when you can use grouping. 

Grouping columns helps you organize, summarize, and format data neatly. Say you have data about a group of people. You only need the favorite color of each person. Other details about that person are not needed right now. So you group columns B and C in the image below to hide data.

If you want to change or view more details about the person, click the plus sign on top of the column. Now, you can view the other columns as well. 

Grouping and ungrouping columns in Google Sheets

• Grouping columns in Google Sheets
• Collapsing and expanding columns
• Multilayered grouping of columns
• Ungrouping columns in Google Sheets

Read more

3 Methods of deleting empty rows in google sheets

• Filter and delete the empty rows
• Sort the complete data set and delete empty rows
• Delete empty rows using an add on

Read more