Guides
Practical guides to working with Ablebits add-ons for Google Sheets and Docs, with the exact steps for everyday jobs in spreadsheets and documents.
Search guides…
Guides by product
11 guidesNewest first
How to bulk generate PDFs in Google Docs: Legal Notices, Letters & Billing Statements
Victoria Kudryashova · Published Sep 17, 2026
Learn how to bulk generate printable PDFs in Google Docs from Google Sheets data using Easy Mail Merge for rent increase notices, billing statements, and legal demand letters.
Easy Mail Merge
How to Use Doc Tools for Google Docs
Natalia Sharashova · Updated Sep 15, 2026
Five add-ons in one sidebar: 12 one-click text tools, custom styles, mail merge, merge to letter and PDF, and document navigation. Start here and jump to the tool you need.
Doc Tools
How to Explore and Navigate a Google Doc
Natalia Sharashova · Updated Sep 14, 2026
Browse a long Google document by headings, bookmarks, links, images and tables from one sidebar, and run a search that filters every tab at once.
Search & Navigate
How to Create and Apply Styles in Google Docs
Natalia Sharashova · Updated Sep 11, 2026
Format a whole Google document in one click, or restyle a single paragraph. Build your own style sets, edit the 20 built-in ones, use custom fonts, and share styles with your team.
Styles
How to count and sum cells by color in Google Sheets: Use Cases
Victoria Kudryashova · Published Sep 8, 2026
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.
Function by Color
How to Remove Duplicates in Google Sheets: Use Cases
Victoria Kudryashova · Updated Sep 6, 2026
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.
Remove Duplicates
How to clean and structure text in Google Sheets: Use Cases
Victoria Kudryashova · Published Sep 2, 2026
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.
Power Tools
How to Change Case in Google Sheets: Use Cases
Victoria Kudryashova · Published Aug 25, 2026
Learn how to quickly change text case in Google Sheets to uppercase, lowercase, proper, or sentence case, and fix messy capitalization without complex formulas.
Power Tools
How to Compare Columns in Google Sheets: Use Cases
Victoria Kudryashova · Published Aug 18, 2026
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.
Compare Sheets
How to run Google Sheets add-ons on a schedule
Victoria Kudryashova · Published Aug 12, 2026
Learn how to automate repetitive Google Sheets tasks on a recurring schedule. Set up background merging, updates, and cleanup without writing Google Apps Script.
Merge Sheets
How to Merge and Combine Google Sheets: Use Cases
Victoria Kudryashova · Published Aug 7, 2026
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.
Merge Sheets