Excel at Work

How To Use Copilot In Excel To Find and Fix Formula Errors

Worried there might be mistakes lurking in your spreadsheet? In this video, I’ll show you how to use *Copilot in Excel* to find and fix errors quickly — even if you’re not technical. If you use Excel every day, it’s easy for small errors to sneak in — especially formulas that break or get accidentally overwritten. In this tutorial, I show you exactly how Copilot in Excel checks your worksheet for errors and can even fix them automatically. This video is perfect for everyday Excel users, admins, and office professionals who want extra confidence before sharing a file. By the end, you’ll know when to use *Chat mode* and when to use *Allow Editing*, and how to avoid costly spreadsheet mistakes. *Download the practice* file and follow along: https://www.excelatwork.co.nz/2026/04/23/use-copilot-in-excel-to-find-and-fix-formula-errors/ In this Excel tutorial, you'll learn: 00:00 How To Use Copilot In Excel To Find and Fix Formula Errors 00:20 Open and access Copilot in Excel 00:53 Understand Chat only vs Allow Editing 01:13 Ask Copilot to check your worksheet for errors 01:31 Identify formula mistakes and hard‑coded values 02:30 Fix Errors using Copilot, Allow Editing 03:27 Get Copilot to fix all errors automatically 04:44 Confidently check a spreadsheet before sharing it *RELATED VIDEOS:* ⭐ *How to Remove Excel #DIV/0 Error* Learn how to remove #DIV/0 error in Excel and ensure accurate calculations with these super-easy yet powerful formulas and tips. https://youtu.be/XMPF1aniRYw ⭐ *How to Apply a Filter in Excel STEP BY STEP* Learn how to add a filter in Excel with this step-by-step tutorial! Whether you need to filter by date, text, or numbers, add multiple filters, or use search filters, this guide will show you how. https://youtu.be/o-lBrq8lQ-0 ⭐ *How to GO TO a SPECIFIC CELL In Excel* Learn how to go to a specific cell in Excel. This tutorial will show you a simple yet powerful tip on quickly jumping to any cell you want. https://youtu.be/5nDiMbfR9g4 🔔 WEEKLY SUPER TIPS WEEKLY SUPER TIPS delivered directly to your inbox!: https://www.excelatwork.co.nz/subscribe-eawi-weekly-tips/ 🔔 👨‍💻 Online Excel & Word Courses https://www.excelatwork.co.nz/self-paced/online-excel-courses-nz/ 📱 SOCIAL Let’s connect on social: https://www.facebook.com/excelatworknz 🎬 For super helpful tips and full tutorials, follow us on our YouTube Channel: https://www.youtube.com/c/excelatwork 📣 Share this with someone who would enjoy this tip 🎉 #copilotinexcel #excelcopilot #exceltips #excelbeginners #microsoft365 #ExcelatWork #SharynBaines