The Ultimate Guide to Using Conditional Formatting in Google Sheets

Conditional Formatting in Google Sheets can be used to highlight/format cells based on the values in it. For example, if you have the scores of 50 students in a subject, you can quickly highlight the students who have scored less than 35 in the exam. Similarly, you can use many such conditions (as we will […]

Continue Reading >>

How to Convert Notepad to a Word Document

A notepad is a basic (and very common) word processing tool that can contain text and line breaks. It does not support any formatting, such as font formatting (bold, italics, alignments), designs, hyperlinks, and tables. It is saved with a .TXT format. At times, you may end up with a notepad document and would need […]

Continue Reading >>

How to Use Spell Check in Google Sheets to Find Misspelled Words

If you work with text in Google Sheets, there is an easy way to run spell check and take care of the misspelled words. As an example, below I have the fruits name in Column A. If you look closely, you can find two misspelled words in it – Aple (instead of Apple) and Strawbery […]

Continue Reading >>

Using IF Function in Google Sheets (with Examples)

IF function in Google Sheets can be used when you want to check a condition and then based on it, returns a specified value if it’s TRUE, or else return the other specified value. For example, suppose you are evaluating marks obtained by students in an exam and you want to know if the student […]

Continue Reading >>

How to Insert Checkbox in Google Sheets

If want to insert checkbox in Google Sheets, you may not find any options for it in the toolbar. Unlike Excel, there is no direct way to do this in Google Sheets. However, you can use a smart data validation technique to get a drop down list with a checkbox option. Something as shown below: […]

Continue Reading >>

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