Google Sheets Tips
Limitations of Google Sheets (Row/Column/File Size)
If you have used Google Sheets even for a few minutes, I am sure you’ve felt that there are some limitations with it. Since I have been a Microsoft Excel user for years now, I
Google Sheets Tips Articles
Google Sheets Tips
How to Hide Columns in Google Sheets (An Easy Guide)
You may not always need all the columns that have the data or extra columns that are empty and need not be displayed. In such cases, you can easily hide columns in Google Sheets. And
Google Sheets Tips
How to Hide Gridlines in Google Sheets (Easy Guide)
Gridlines are something that makes data look good in Google Sheets. By default, Gridlines are already applied to all the cells in Google Sheets. But sometimes, you may only want to have these gridlines (or
Google Sheets Tips
How to Insert Multiple Rows in Google Sheets (with Useful Shortcut)
Watch Video – How to Insert Multiple Rows in Google Sheets In case you prefer reading a tutorial over watching a video, below is a written tutorial for you. When working with data in Google
Formulas
How to Color Alternate Rows in Google Sheets (takes only two-clicks)
Watch Video – How to Color Alternate Rows in Google Sheets (with and without Conditional Formatting) In case you prefer reading over watching a video, below is a written tutorial for you. Google Sheets has
Google Sheets Tips
How to Zoom-In and Zoom-Out in Google Sheets (Shortcuts)
When I started using Google Sheets a few years ago, there was no way to zoom out (or zoom in) in Google Sheets. Being a skilled Microsoft Excel user, this frustrated me to the core.
Formulas
How to Filter By Color in Google Sheets (Using a Formula)
There are some times I wish Google Sheets had some more functionalities like MS Excel. One such functionality that isn’t available in Google Sheets is the ability to filter by color. For example, suppose I
Google Sheets Tips
How to Change Row Height in Google Sheets (Quick & Easy)
There are many cases when you may want to change the row height in Google Sheets. Whether you want to increase or decrease the row height, the steps would remain the same. In this tutorial,
Formulas
How to Change Text Case in Google Sheets (Upper, Lower, or Proper)
In this tutorial, I will show you how to change text case in Google Sheets. You can convert any text into Upper case, Lower case, Proper case (also called the Title case), or Sentence case.
