While working on your Google Sheet, you might come across data that is categorized by color. It could be the cell’s background color or the text color itself. It can be incredibly useful to filter using these colors. For instance, say you have a list of students highlighted in green if they’ve passed and in red if they’ve failed. 

You can create a filter to look at only the passed or failed students.

4 methods to filter by color in Google Sheets

• Using Filter by color from the Filter icon in the toolbar
• Using Filter by color from the Filter option in the menu bar
• Using Google Apps Script
• Using a third-party add-on

Read more

When you’re working on Google Sheets, you might come across data that is distinguished by color. It can be useful to sort the data by color and make the sheet look neater. For instance, take the data of students highlighted in red and green below. Red means they’ve failed a test and green means they’ve passed it.

The same data when sorted by color looks much neater and cleaner. 

4 methods to sort by color in Google Sheets

• Using Sort by color from the Filter icon in the toolbar
• Using Sort by color from the Filter option in the menu bar
• Using Google Apps Script
• Using a third-party add-on

Read more

You may come across merged cells while working on your Google Sheets. The cells can be vertically or horizontally merged. It can look something like this.

When you have merged cells in Google Sheets, it’s difficult to sort or filter the data present in those cells. Fortunately, unmerging cells is as easy as merging them. 

3 methods to unmerge cells in Google Sheets

• Using the Merge cell icon in the toolbar
• Using the Format option in the menu bar
• Using Keyboard shortcuts

Read more

When you’re working on Google Sheets, you might sometimes have data with names. It is possible that you might want to separate the first and last names for mailers, greeting cards, etc. It is especially useful when you’re doing a mail merge. Splitting the names manually might work when you have little data. However, it can become tedious for large amounts of data. 

4 methods to separate first and last names in Google Sheets

• Using the SPLIT formula
• Using Split text to columns
• Using the Split Names add-on
• Using Text functions

Read more

While working on Google Sheets you’d need to underline texts. There are several ways to underline a Google cell, multiple cells, and text. We will cover the many methods and how we can do it with shortcuts. 

2 ways to underline text in Google Sheets

Method 1: Underlining a text string within a cell 

1.1 Underlining the entire string 

1.2 Underlining multiple strings in different cells

1.3 Underlining part of the text string

Method 2: Underlining the cell itself 

2.1 Underlining one cell

2.2 Underlining multiple cells at once

Lets Start.

Read more

You often come across values that you need to round off in a data set. It could be rounding up a number to the nearest two decimal points. You might need to round down a number to the nearest whole number or integer. Google Sheets provides four functions for this. Let’s cover them today.  

4 ways to round numbers in Google Sheets

The four main functions to round numbers are ROUND, ROUNDUP, ROUNDDOWN and MROUND.

Rounding up on Google Sheets follows the general rules as explained below: 

• If the number to the right of the digit to be rounded is less than five, then the digit remains the same. 
• If the number to the right of the digit to be rounded is more than or equal to five, then the function increments the number by 1. 

Method 1: Using ROUND function 

1.1 Rounding off to the nearest whole number 

1.2 Rounding off number to set decimal points

1.3  Rounding off numbers beyond the decimal point 

Method 2: Using ROUNDUP function 

2.1 Rounding up numbers to the next whole number 

2.2 Rounding up numbers while keeping set decimal points intact 

2.3 Rounding up numbers beyond decimal places

Method 3: Using ROUNDDOWN function  

3.1 Rounding down numbers to the next whole number

3.2 Rounding down numbers while keeping set decimal points intact  

3.3 Rounding down numbers beyond decimal places

Method 4: Using MROUND function

Let’s go over the functions in detail.

Read more