Mar 09 2018 09:15 AM
I want to delete old headers & footers that are on the drop-down lists under Page Setup - Header/Footer. How can I delete these?
Mar 09 2018 09:29 AM
Mar 09 2018 09:59 AM - edited Mar 09 2018 10:01 AM
SolutionHello Keith,
Some of them are just suggestions based on the username, file name, current date, and so on.
So you cannot delete them, they are built-in!
But if you have some custom headers and footers already found in the workbook, you will see them in the drop-down list.
If you want to delete all the custom headers and footer from your workbook at once, you can do it as follows:
Hope that helps!
Haytham
Mar 15 2018 09:24 AM
Haytham,
Thank you very much - that did it!
Keith
Mar 09 2018 09:59 AM - edited Mar 09 2018 10:01 AM
SolutionHello Keith,
Some of them are just suggestions based on the username, file name, current date, and so on.
So you cannot delete them, they are built-in!
But if you have some custom headers and footers already found in the workbook, you will see them in the drop-down list.
If you want to delete all the custom headers and footer from your workbook at once, you can do it as follows:
Hope that helps!
Haytham