Select the “Header” or “Footer” drop-down menu on either the “Insert” tab or “Header & Footer” tab, then choose “Remove Header” or “Remove Footer.” Note: be sure to clean up the data in your Excel ...