How do I find REF errors in Excel? Follow the steps below to find errors located in your Excel spreadsheet: Press Ctrl + F or click the Find and select button on the Home tab in the Editing group.