clearing header/footer list

  • Thread starter Thread starter Sammy
  • Start date Start date
S

Sammy

How can you clean out the header/footer list that includes
pre-defined entries plus any custom entries that get made?

Thanks
 
Sammy

You can't clear out the pre-defined entries that Excel has as default.

The only way I know to clear out the others is to CRTL + A to select all cells
on a sheet then paste to a new sheet in a new workbook.

The customs won't move with the cells.

Don't copy the sheet, otherwise the customs go with.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I customise the list of pre-defined headers in Excel? 1
Including document property values in Excel headers 2
Excel Footers 1
Insert file name in header without showing extension 1
Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2
headers footers 3
Change Header & Footer Info w/ Worksheet Option Buttons 1
Header and Footer 3

Back
Top