Tag: automate Google Sheets

How to Delete All Rows with Specific Text in Google Sheets (Manual + Script)

Jun 26, 2025

—

by

Himanshu

in Google Tools Training

🗑️ How to Delete All Rows Containing Specific Text in a Column in Google Sheets When working with large datasets, you may need to delete all rows where a certain word or value appears in a specific column — like removing all rows where column B says “Cancelled”. You can do this manually, with filters,…
How to Get a List of Sheet Names in Google Sheets (Step-by-Step)

Jun 26, 2025

—

by

Himanshu

in Google Tools Training

Google Sheets doesn’t offer a built-in formula to list sheet names directly like Excel VBA might. However, you can achieve it easily using Google Apps Script. Here’s how: ✅ Step 1: Open Google Apps Script ✅ Step 2: Paste This Script In the script editor, paste the following code: javascriptCopyEditfunction listSheetNames() { const ss =…