If you work long hours on Google Sheets, switching to Dark Mode will be great for you to avoid straining the eyes. You can choose this for aesthetic reasons as well.
We will cover how to turn on Dark Mode on Android and desktop/laptop browsers.
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.
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.
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.
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
2.1 Underlining one cell
2.2 Underlining multiple cells at once
Lets Start.
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.
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:
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
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
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
Let’s go over the functions in detail.
Checking for the highest or lowest value in a data set comes in handy on many occasions. To do this on Google Sheets, there are easy and efficient custom formulae that you can use.
We have got you covered. We have compiled the most comprehensive tutorial to guide you.
1.1 Highest value within a range
1.2 Lowest value within a range
2.1 Highest value within a column
2.2 Lowest value within a column
3.1 Highest value within a row
3.2 Lowest value within a row
4.1 Highlight top N cells with the highest value
4.2 Highlight top N cells with the lowest value
5.1 Highlight row with the highest value
5.2 Highlight row with the lowest value
Let’s go over the methods one by one, starting with highlighting values within a cell range.
In your Google Sheet, you might have checkboxes to know what is done and to be done. Say you want to count the checkboxes in your sheet. Google Sheet allows you to count the checkboxes easily.
In this tutorial, we will share 3 methods to count colored cells in a google sheet.