Everyday Web
A Spreadsheet Error Is a Clue: Start with DIV/0, REF and N/A
DIV/0, REF and N/A point to different spreadsheet problems. Follow the broken calculation before using IFERROR to make the warning disappear.
EVERYDAY DIGITAL KNOW-HOW
Spreadsheet Basics
Learn Better
The Number in a Cell Might Be the Result of a Formula
Look beyond a spreadsheet cell’s displayed number to understand whether it contains a calculation or a fixed entry before editing it.
Digital Habits
Keep the Header in View While Reading a Long Spreadsheet
Practise freezing a header row in Google Sheets so column labels stay visible while scrolling. Use a small sample to check the result and learn how to undo it.