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 ...

First, delete any numbers you have already typed automatically in column A. To do this, press Ctrl+Shift+Home to go to cell A1 before using the Arrow keys to navigate to the correct cell.