Google Sheets Intermediate Tutorials
How to Count Checkboxes in Google Sheets (5 Quick Tricks)
Learn how to count checked and unchecked checkboxes in Google Sheets using COUNTIF, COUNTIFS, ARRAYFORMULA, and Apps Script methods.
Read article
Author & Spreadsheet Consultant
Mohammed Shafin Arshad
111 Articles PublishedPublishing since
Mohammed Shafin Arshad is a Computer Science student and cybersecurity enthusiast in Malaysia with 6 years of Excel and Google Sheets experience. He specializes in VBA, macro automation, and SaaS-focused workflow guides. His background includes university data science projects, and he enjoys using macros to solve complex spreadsheet problems.
Editorial Review
Articles Published by Mohammed Shafin Arshad
Articles by Mohammed Shafin Arshad are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Google Sheets Basics
How to Find Merged Cells in Google Sheets (3 Simple Tricks)
Learn how to find merged cells in Google Sheets using Apps Script, filters, and quick tips to identify and list merged cells easily.
Read article
Google Sheets Basics
How to Use Custom Number Formats in Google Sheets
Learn how to use custom number formats in Google Sheets to add leading zeros, currency, units, abbreviations, and highlight negative numbers.
Read article
Google Sheets Basics
How to Go to the Next Line in Google Sheets in the Same Cell
Learn how to go to the next line in the same Google Sheets cell using shortcuts, CHAR(10), Excel import, or Apps Script.
Read article
Google Sheets Basics
How to Autofill Cells in Google Sheets Based on Another Column
Learn how to autofill cells in Google Sheets based on another column using VLOOKUP, ARRAYFORMULA, IF statements, or custom Apps Script rules.
Read article
Google Sheets Basics
How to Autofill Date When a Cell Is Updated in Google Sheets
Autofill date in Google Sheets when a cell is updated using Apps Script or checkbox triggers with automatic timestamping options.
Read article
Google Sheets Basics
How to Extract a URL from a Hyperlink in Google Sheets
Extract URLs from hyperlinks in Google Sheets using REGEXEXTRACT formulas or Apps Script for both formula-based and manually added links.
Read article
Google Sheets Intermediate Tutorials
How to Recover Deleted Google Sheets After 30 Days
Learn how to recover deleted Google Sheets after 30 days using Google Support, Vault, collaborator access & version history.
Read article
Google Sheets Basics
How to Search for Text in a Range in Google Sheets
Learn how to search text in a range in Google Sheets using COUNTIF, FILTER, SEARCH, conditional formatting, and the Find tool.
Read article
Google Sheets Intermediate Tutorials
Data Validation Based on Another Cell in Google Sheets
Learn how to use data validation in Google Sheets based on another cell using fixed cell rules, row-based conditions, or Google Apps Script.
Read article
Google Sheets Formulas
How to Reference a Cell in Another Sheet in Google Sheets
Learn how to reference a cell from another sheet in Google Sheets using direct links, INDIRECT function, and tips to avoid common errors.
Read article
Google Sheets Intermediate Tutorials
How to Create a Dependent Drop-Down List in Google Sheets
Learn how to create a dependent drop-down list in Google Sheets using Named Ranges, INDIRECT, FILTER function, or Google Apps Script.
Read article