How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google Sheets: Using Keyboard Shortcuts. Using Google Sheet Functions. Using Script. Insert Timestamp Using Keyboard Shortcuts If you’re looking to manually […]

Continue Reading >>

How to Protect a Range of Cells in Google Sheets

Google Sheets are amazing as you can easily share and collaborate with others. One of the issues that come with working on a shared Google Sheet is that anyone can make a change in it. This may not be something you want. So you can easily protect a range of cells in Google Sheets and make […]

Continue Reading >>

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 >>
1 2 3