How can I clear the list of built-in footers in Excel?

G

Gary Brown

Assuming you are talking about Print Footers:

Select...
FILE / PAGE SETUP / CUSTOM FOOTER

Then highlight the section (left, center or right) and delete the contents.

Select...
OK / OK

Programatically, you would use something like...
'/============================/
Sub FootersDelete()
With ActiveSheet.PageSetup
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With
End Sub
'/============================/

HTH
 
G

Gord Dibben

Willy

You don't.

The only thing you can change in there is the user name at
Tools>Options>General and the Author you find under File>Properties>Summary.


Gord Dibben Excel MVP
 
Top