How to Quickly Merge Cells in Google Sheets

Watch Video – Merge Cells in Google Sheets   When you work with data that has headers, sometimes, you may feel the need to merge cells in Google Sheets. For example, if you have a main header as Revenue and subheaders as 2016, 2017, and 2018, you can merge the three cells that make up […]

Continue Reading >>

How to Quickly Freeze Rows in Google Sheets

Watch Video – How to Freeze Rows and Column in Google Sheets   You may want to freeze rows in Google Sheets if you’re working with a large dataset that requires you to scroll up and down a lot. Freezing rows at the top would make those rows visible all the time so that you […]

Continue Reading >>

The Ultimate Guide to Google Sheets VLOOKUP Function (with Examples)

Google Sheets VLOOKUP function can be used to look for a value in a column and when that value is found, return a value from the same row from a specified column. Now if that description sounds nerdy and difficult, here is another way to understand what this function does. Suppose you have gone to […]

Continue Reading >>

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 in Excel (where you can insert a check box using the developer tab), there is no direct way to do this in Google Sheets. However, you can use a smart data validation technique to get a drop […]

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 >>