Follow the steps below on how to ignore blank cells in Excel: Select a blank ... will use and drag the auto fill handle down to the cells you need to apply this formula. Then click the Insert ...