ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Deleting Headers and Footers that are in the drop down Menu? (https://www.excelbanter.com/excel-discussion-misc-queries/133373-deleting-headers-footers-drop-down-menu.html)

Lisa

Deleting Headers and Footers that are in the drop down Menu?
 
There are header and footer options that were automatically stored from
certain documents that other people created that i opened and do not want to
use or keep in the drop down. Is there a way to get rid of these?

Gord Dibben

Deleting Headers and Footers that are in the drop down Menu?
 
Lisa

FileProperties

Delete Author Name etc. in Summary and anything you don't like in Custom

Save the file/close and reopen.


Gord Dibben MS Excel MVP

On Mon, 5 Mar 2007 09:27:02 -0800, Lisa wrote:

There are header and footer options that were automatically stored from
certain documents that other people created that i opened and do not want to
use or keep in the drop down. Is there a way to get rid of these?




All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com