If you have a long list of emails, you can evaluate whether these emails are even real or not, using the ISEMAIL function. Suppose we have a list of emails in cell range A2:A5 in a given spreadsheet.

To display a tooltip, you may use Comments, Notes, Data Validation Help Text, or Screen Tips. Let us see how they work in Excel and Google Sheets.