Google Sheets guides
Practical guides to working with Ablebits add-ons for Google Sheets, with the exact steps for everyday jobs in spreadsheets.
7 guidesNewest first
How to count and sum cells by color in Google Sheets: Use Cases
Learn how to count and sum cells by fill and font color in Google Sheets. Track project progress, calculate shift hours, and sum budget expenses easily.
How to Remove Duplicates in Google Sheets: Use Cases
Learn how to remove duplicates in Google Sheets across 5 real-world scenarios. Clean CRM lists, keep the latest entry, and auto-delete duplicates easily.
How to clean and structure text in Google Sheets: Use Cases
Learn how to clean text, extract emails, standardize phone numbers, and split full names in Google Sheets without complex formulas through real-world use cases.
How to Change Case in Google Sheets: Use Cases
Learn how to quickly change text case in Google Sheets to uppercase, lowercase, proper, or sentence case, and fix messy capitalization without complex formulas.
How to Compare Columns in Google Sheets: Use Cases
Learn how to compare two columns in Google Sheets to find duplicates, highlight differences, remove duplicate values, or match case-sensitive data without complex formulas.
How to run Google Sheets add-ons on a schedule
Learn how to automate repetitive Google Sheets tasks on a recurring schedule. Set up background merging, updates, and cleanup without writing Google Apps Script.
How to Merge and Combine Google Sheets: Use Cases
Learn how to merge two Google Sheets by key column and combine multiple tabs or files into one master sheet without VLOOKUP or complex formulas through real-world use cases.