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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

Edit Built in Footer 2
Printing Excel File Custom Properties in the Footer 3
How do I save a built-in header in Excel? 1
Why can't I access the footer? 10
Excel Unique last page footer 1
how to set up a built in header footer in excel 5
Custom Footer 2
How do I invoice a cost to a custom built MS Access Accounting Database? 0

Back
Top