Category Archives for Google Sheets Tips

How to Quickly Insert Multiple Rows in Google Sheets

5 new rows inserted in Google Sheets

What do you do when you want to insert multiple rows in Google Sheets? Do you insert one row at a time? While this can be a valid way to do this, it is time-consuming and inefficient. Let me show you a faster way to insert multiple rows in Google Sheets. Suppose you have a […]

Continue Reading >>

How to Rotate Text in Google Sheets (in less than 5 seconds)

Rotate Text in Google Sheets

Google Sheets has some great data formatting tools. One such formatting feature is the ability to rotate text within a cell in Google Sheets. Something as shown below: Here are the two ways you can rotate text in Google Sheets: Using the Toolbar Using the Format Options Using the Toolbar Here are the steps to rotate […]

Continue Reading >>

How to Count Cells If Not Blank in Google Sheets

Count Cells If Not Blank in Google Sheets - Countif

Sometimes you may have a dataset where some of the cells or rows are blank. In such a case, if you want to count cells that are not blank, then you need to rely on Google Sheets count functions. In this tutorial, I will show you how to count cells if not blank in Google […]

Continue Reading >>

Conditional Formatting Based on Another Cell Value in Google Sheets

Conditional Formatting Based on Another Cell in Google Sheets - multilple result

In this tutorial, you will learn how to highlight cells using conditional formatting based on another cell in Google Sheets. This can be done using the custom function option in conditional formatting.

Continue Reading >>

Creating a Heat Map in Google Sheets (Step-by-Step Tutorial)

Heat Map in Google Sheets - Example

A heat map is a good visual analysis layer to add to your data set to get some insights quickly. For example, if you have students marks in columns, you can use a heat map in Google Sheets to identify students who failed or students who scored above 90. Similarly, if you have sales data, […]

Continue Reading >>

How to Split Text to Columns in Google Sheets (with Examples)

Watch Video – How to Split Text to Columns in Google Sheets You can use the Split Text to Columns in Google Sheets to quickly split the contents of a cell (or a range of cells). Split Text to Columns in Google Sheets Split Text to Columns feature comes in handy when you want quickly […]

Continue Reading >>

How to Convert Excel to Google Sheets (a Step-by-Step Tutorial)

If you work with Google Sheets, there may be times when you have to convert Excel to Google Sheets. This allows you to collaborate with others and benefit from the powerful features of Google Sheets. There are a couple of ways to convert Excel to Google Sheets: Convert by importing an Excel file to Google […]

Continue Reading >>

How to Zoom In and Zoom Out in Google Sheets

One of the basic features that is missing in Google Sheets (at least at the time of writing this article) is that ability to Zoom In and Zoom Out in Google Sheets. That’s one point to the Microsoft Excel team! Now, since there is no option to zoom in Google Sheets, how can we avoid […]

Continue Reading >>

How to Create a Dependent Drop Down List in Google Sheets

A drop down list in Google Sheets can be used when you want to show a list of options and the user can select from it. It helps in speeding up data entry and makes it more reliable. In real life, there would be a need to create a dependent drop down list where the once […]

Continue Reading >>

Leave Tracker Template in Google Sheets

Looking for a leave tracker template in Google Sheets that can track leaves of your employees or students? You’re at the right place. In this post, I am sharing one of my best templates – the leave tracker template in Google Sheets. Click here to access the leave tracker template [You will have to make a […]

Continue Reading >>
1 2 3