How to add a new line in cell in Google Sheets

So, in this tutorial we will see how to jump to a new line or insert a line break while typing in a cell. Suppose we have a data set […]

Why Vlookup evaluates to an out-of-bound range in Google Sheets(+ diagnosis)

While working in google sheets one might encounter an error that Vlookup evaluates to an out of bound range as shown in the image above. So let’s see how the […]

How to use IFERROR in Google Sheets

We often come across situations where we try to use a formula and we get an error instead of the desired result. Whether it is Microsoft Excel or Google Sheets, […]

How to concatenate in Google sheets

This feature allows users to combine the different cell’s data in one cell. It does not depend upon the symmetry of data. Users can easily combine data from different cells.To […]

How to use SQL Max in Google Sheets to find latest date

Let’s consider the following dataset which contains the details of the sales orders and we wish to find the 5 latest orders placed by our sales reps in any region. […]

How to use Checkboxes in Google Sheets

In this tutorial we are going to learn how to add and then use the checkboxes (tick boxes) in Google sheets. Google Sheets has termed Check boxes as “Tick boxes” […]

How to make yahoo currency converter in Google Sheets

Google sheets have a built in function of Google Finance. With the help of this we can easily convert the currency. The generic formula is as follows; GOOGLEFINANCE(ticker, [attribute], [start_date], […]

How to add columns in google sheets

You can watch a video tutorial here. There may be times when you would like to add new columns into an existing Google Sheet. There are two solutions to do […]

How to freeze a row in google sheets

You can watch a video tutorial here. Any number of rows and/or columns in a Google sheet can be frozen so that they always stay in the same place while […]

How to search in google sheets

You can watch a video tutorial here. Should you wish to find a particular piece of text or number in a Google Sheet there are two solutions. Solution 1: Keyboard […]

How do you lock cells in google sheets

How do you lock a row in google sheets

How do you freeze panes in google sheets

Google sheets offer a very interesting way to freeze panes. We can freeze single or multiple rows and columns in google sheets. We can perform the below mentioned way to […]

How do you freeze a column in google sheets

How do I lock a row in google sheets