Category: Google Spreadsheet Tips

How to repeat a cell value to n times in google sheets

How to repeat a cell value to n times in google sheets

Assuming you have data in Column A, a list of products and you want to repeat them in the next column or in another sheet to n times. Let's assume yo ...
How to fill down blank rows using Arrayformula in Google Sheets

How to fill down blank rows using Arrayformula in Google Sheets

Assuming you have data in Column A, a list of products but it has some blank rows in between and you want to fill them down with product name itself. ...
How to get sheets name and rename them using Google Script

How to get sheets name and rename them using Google Script

Renaming all sheets in Google Sheets is a tedious task. If you do it manually, it'll kill your valuable time. Let's see How to get sheets name and re ...
How to use REGEX formulas in Google Sheets

How to use REGEX formulas in Google Sheets

REGEX formula is a great function created for Google Sheets. You will not find this function in MS EXCEL, you have to write a VBA script to apply reg ...
How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet

How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet

How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet Removing unwanted text from multiple datasets is a tedious task, but Googl ...
How to send email notifications on Google Spreadsheets if any cell value changes

How to send email notifications on Google Spreadsheets if any cell value changes

How to send email notifications on Google Spreadsheets if any cell value changes Working on Google Spreadsheets is fun, you can do a lot with Goog ...