To show up where the missing sequential numbers are within the list, use conditional formatting to show e.g. a coloured background on the cell after the missing number. To set it up, follow - "Format, ...

Microsoft Excel: How to Find Missing Numbers in a Sequence. Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate ...