Free Help Guides

Excel & Google Sheets problem-solving articles

Practical guides for common spreadsheet problems. If the guide does not fix it, send the problem over for help.

How to Fix a #REF! Error in Excel

Learn what causes a #REF! error in Excel and how to fix broken cell references step by step.

Read the guide →

XLOOKUP Not Working? Common Problems and Fixes

Fix common XLOOKUP problems including #N/A, wrong results, mismatched data types and incorrect lookup ranges.

Read the guide →

Why Is My Excel Formula Not Calculating?

Troubleshoot Excel formulas that show the formula as text, return old values or fail to update automatically.

Read the guide →

How to Fix a Slow Google Sheet

Speed up a slow Google Sheet by reducing expensive formulas, imports, volatile functions and unnecessary formatting.

Read the guide →

Why Excel Keeps Changing Your Date Format

Stop Excel from misreading dates and swapping day and month values when importing or editing data.

Read the guide →

How to Remove Duplicate Data in Excel

Find and remove duplicate rows in Excel without accidentally deleting valid records.

Read the guide →

Excel VLOOKUP vs XLOOKUP: Which Should You Use?

Understand the differences between VLOOKUP and XLOOKUP and when to use each formula.

Read the guide →

How to Automate a Spreadsheet

Learn how to identify repetitive spreadsheet work and automate Excel or Google Sheets safely.

Read the guide →

Can't find your problem?

Describe what your spreadsheet is doing and what you want it to do instead. You can get help with Excel, Google Sheets, formulas, automation, dashboards and broken files.

Ask for help