1. Open your Spreadsheet where you have entered header and footer.
2. Click Insert.
3. Select Header & Footer.
4. Manually delete all inserted headers, footers, plus any additional info, if any. On a Header and Footer dropdowns, select (none).
5. Click OK.