How to Sort Data in Google Sheets

If you work with data in Google Sheets, sorting is a feature you would need quite often. In this tutorial, you’ll learn how to sort data in Google Sheets. Sort Data in Google Sheets Suppose you have students marks data in a Google Sheet as shown below: Now you can sort this data with names […]

Continue Reading >>

How to Wrap Text in Google Sheets

Google Sheets can be used to store various types of data. It could be Names, Address, long form text, links, etc. In most of the cases, when the text in the cell is long and goes out to the cell, there is a need to wrap it within the cell. Wrap Text in Google Sheets […]

Continue Reading >>

How to Insert an Image in a Cell in Google Sheets

Normally, the way people insert an image in a cell in Google Sheets is by going to Insert –> Image and the selecting the image or specifying the URL. The issue with this method is that it treats the image as an object and hence it doesn’t move or size with the cells. If you […]

Continue Reading >>

How to Quickly Split Text in Google Sheets

A lot of times, you may want to split the text strings into two or more columns in Google Sheets. For example, if you have names, you may want to split the first name and the second name. Similarly, if you have an¬†address, you may want to split the address elements (such as house numbers, […]

Continue Reading >>

How to Insert Bullets in Google Sheets

While there is a simple click option available to insert a bullet in Google Docs, there is no easy way to insert bullets in Google Sheets. Now the reason could be that the need for bullet points is less in Google Sheets. But if you are one of those who wants a bulleted list, there […]

Continue Reading >>

How to Count the Number of Words in Google Sheets

You can easily count the number of words in a text string in Google Sheets. All you need is some know-how of the Text Functions (LEN and SUBSTITUTE). Count the Number of Words in Google Sheets Suppose you have a few text strings as shown below: There are different text strings here of varying length. […]

Continue Reading >>

How to Remove Duplicates in Google Sheets

If you want to remove duplicates in Google Sheets, you need to use the UNIQUE function. This function extracts all the unique values and puts it in another place on the sheet. This is very different than the way you can remove duplicates in MS Excel. In Excel, there is an option in the data […]

Continue Reading >>

How to Color Alternate Rows in Google Sheets

There is no straightforward ¬†way to color alternate rows in Google Sheets, however, you can use Conditional formatting to do this. Coloring the alternate rows increases the readability of the data. These are also called the zebra lines. Color Alternate Rows in Google Sheets Suppose I have a dataset as shown below: Here are the […]

Continue Reading >>

How to Create a Drop Down List in Google Sheets

A drop down list in Google Sheets can be helpful when you want the user to select from pre-defined options. It’s a great way to make the data entry consistent. For example, a user from a drop down list can select easily the country as the US. But if you give him the option to […]

Continue Reading >>

How to Change the Default Font in OneNote

By default, the font in Microsoft OneNote is Calibri and the font size is 11. If you don’t like the default font and want to change it, you can do that easily in a couple of clicks. How to Change the Default Font in OneNote Here are the steps to change the default font in […]

Continue Reading >>
1 2 3