ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Delete Header and Footer (https://www.excelbanter.com/excel-discussion-misc-queries/158186-delete-header-footer.html)

Pat J

Delete Header and Footer
 
In Excel 2007 I mistakenly added a header. How do I get rid of it? In 2003
it was only a "right click" away.


--
Pat J

Duke Carey

Delete Header and Footer
 
You question titles says header AND footer, but you mention only header.

By 'header' I'm assuming you mean freeze panes? It's on the View tab on the
ribbon. You can also get to it by pressing Alt-W, then F. If you already
have pnes frozen, you will see the option to Unfreeze panes

"Pat J" wrote:

In Excel 2007 I mistakenly added a header. How do I get rid of it? In 2003
it was only a "right click" away.


--
Pat J


Pat J

Delete Header and Footer
 
Thanks Duke,
I really did mean "headers as well as footers". I accidentally created a
header on the Insert tab on the ribbon. It then took me to the headers
design ribbon. I don't see any place to delete the entire header. It is my
preference to use freeze paines. The same syntax exists for footers, so
there is a similar issue with deleting footers.
--
Pat J


"Duke Carey" wrote:

You question titles says header AND footer, but you mention only header.

By 'header' I'm assuming you mean freeze panes? It's on the View tab on the
ribbon. You can also get to it by pressing Alt-W, then F. If you already
have pnes frozen, you will see the option to Unfreeze panes

"Pat J" wrote:

In Excel 2007 I mistakenly added a header. How do I get rid of it? In 2003
it was only a "right click" away.


--
Pat J


Duke Carey

Delete Header and Footer
 
If you can see the Header on-screen and it DOES NOT read "Click to add
header" then it doesn't really exist and it's simply that you are in Page
Layout mode. You can get back to normal mode by clicking on the little icons
in the bottom right corner, just to the left of the View Zoom slider

If you can actually see the header you can either click on it to activate it
and delete the text or go back to the Header & Footer button and then delete
the text. Then use the steps described above to get back to Normal mode

"Pat J" wrote:

Thanks Duke,
I really did mean "headers as well as footers". I accidentally created a
header on the Insert tab on the ribbon. It then took me to the headers
design ribbon. I don't see any place to delete the entire header. It is my
preference to use freeze paines. The same syntax exists for footers, so
there is a similar issue with deleting footers.
--
Pat J


"Duke Carey" wrote:

You question titles says header AND footer, but you mention only header.

By 'header' I'm assuming you mean freeze panes? It's on the View tab on the
ribbon. You can also get to it by pressing Alt-W, then F. If you already
have pnes frozen, you will see the option to Unfreeze panes

"Pat J" wrote:

In Excel 2007 I mistakenly added a header. How do I get rid of it? In 2003
it was only a "right click" away.


--
Pat J


TERRY HOWARD

Delete Header and Footer
 
HOW DO YOU DELETE HEADERS OR FOOTERS?

On Thursday, September 13, 2007 4:04 PM Pat wrote:


In Excel 2007 I mistakenly added a header. How do I get rid of it? In 2003
it was only a "right click" away.


--
Pat J



On Thursday, September 13, 2007 4:48 PM DukeCare wrote:


You question titles says header AND footer, but you mention only header.

By 'header' I'm assuming you mean freeze panes? It's on the View tab on the
ribbon. You can also get to it by pressing Alt-W, then F. If you already
have pnes frozen, you will see the option to Unfreeze panes

"Pat J" wrote:



On Thursday, September 13, 2007 6:38 PM Pat wrote:


Thanks Duke,
I really did mean "headers as well as footers". I accidentally created a
header on the Insert tab on the ribbon. It then took me to the headers
design ribbon. I don't see any place to delete the entire header. It is my
preference to use freeze paines. The same syntax exists for footers, so
there is a similar issue with deleting footers.
--
Pat J


"Duke Carey" wrote:



On Friday, September 14, 2007 7:46 AM DukeCare wrote:


If you can see the Header on-screen and it DOES NOT read "Click to add
header" then it doesn't really exist and it's simply that you are in Page
Layout mode. You can get back to normal mode by clicking on the little icons
in the bottom right corner, just to the left of the View Zoom slider

If you can actually see the header you can either click on it to activate it
and delete the text or go back to the Header & Footer button and then delete
the text. Then use the steps described above to get back to Normal mode

"Pat J" wrote:





Jim Cone[_2_]

Delete Header and Footer
 

That depends on the Excel version you are using.
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware .
(Special Print XL add-in: long columns printed side by side) .





"TERRY HOWARD"
wrote in message
...
HOW DO YOU DELETE HEADERS OR FOOTERS?





All times are GMT +1. The time now is 09:14 AM.

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