How To Add Numbers In Excel Automatically, On the Insert tab, in the Text group, select Header & Footer.