How to Quickly Freeze / Lock Rows in Google Sheets
Watch Video – How to Freeze / Lock Rows and Column in Google Sheets You may want to freeze/lock rows
Category: Google Sheets Tips & Tutorials
Using IFERROR Function in Google Sheets (with Examples)
If you work with formulas in Google Sheets, you would know that errors can pop-up any time. While getting errors
How to Create a Drop Down List in Google Sheets
A drop-down list in Google Sheets can be helpful when you want the user to select from pre-defined options. It’s
Using IMPORTFEED in Google Sheets to Fetch Feed from URL
IMPORTFEED function in Google Sheets can be used to import the RSS feed in the worksheet. This can be useful
Using Query Function in Google Sheets – Examples
QUERY function is one of the best and most useful functions in Google Sheets. When used to its full potential,
Concatenate in Google Sheets – Combine Cells Using Formula
If you have content in different cells and you want to combine it, Google Sheets provide a couple of useful
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)
How to Quickly Transpose Data in Google Sheets
While working with data, sometimes you may need to transpose data in Google Sheets. But you don’t need to do
How to Fill Down in Google Sheets Using Fill Handle
Fill handle in Google Sheets can save you a lot of time when doing data entry or working with data.
Calendar Template in Google Sheets (Monthly and Yearly)
Wondering how to make a calendar in google sheets? You can easily create a simple static calendar template in Google Sheets. However, you would need to update
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
How to Create Named Ranges in Google Sheets (Static & Dynamic)
Named Ranges in Google Sheets can be used to define a cell or a range of cells and give it