<!-- from fixya rte -->How to delete a header/footer in excel 2010? - Microsoft Computers & Internet

Assuming Word 2010/2013:
Go to the footer
From the "header & footer tools" menu select "Page Number"
format as desired.

Insert The Chapter Number And Title In A Header Or Footer

First divided your document into sections in order to insert chapter numbers and titles into headers and footers.

1. If you haven't done so already, insert a section break where you want to start a new section that contains a different chapter.
a. Click where you want to insert a section break.
b. On the Insert menu, click Break.
c. Under Section break types, click the option that describes where you want the new section to begin.

Note: If you have already inserted a page break to cause the chapter to start on a new page, delete the page break and replace it with a section break that starts on a new page.

2. Apply a built-in heading style to the chapter number and chapter title by clicking a heading style in the Style box on the Formatting toolbar.

Or to have Microsoft Word automatically number headings, use the Bullets and Numbering dialog box to format chapter headings.

a. On the Format menu, click Bullets and Numbering, and then click the Outline Numbered tab.
b. Click a chapter-numbering style (one that includes the text "Heading 1" or "Heading 2," and so on), and then click OK.
c. Type the text you want for the numbered heading, and then press ENTER.
d. To add the next numbered heading, go to the next chapter heading, click the arrow next to the Style box on the Formatting toolbar, and then select the heading style you specified in step 2.

===========================================

1. In the first chapter, on the View menu, click Header and Footer.

2. If necessary, move the insertion point to the header or footer you want to change.

3. Insert the chapter number or title.
a. On the Insert menu, point to Reference, and then click Cross-reference.
b. In the Reference type box, click Heading.
c. In the For which heading box, click the heading that contains the chapter number and title.
d. In the Insert reference to box, select what you want to insert in the header or footer. For example,
• Click Heading number to insert the chapter number.
• Click Heading text to insert the chapter heading.
e. Click Insert, and then click Close.

4. Click Show Next Button image to move to the header or footer of the next chapter.

5. If the header or footer in this chapter matches the one you just created, click Link to Previous Button image on the Header and Footer toolbar to break the connection between the header or footer in the current chapter and the previous chapter.

6. If there's already text in the header or footer that you don't want, delete the text before inserting the chapter number and title.

7. Repeat step 5 to insert the chapter number or title of the current chapter.

8. For each chapter in the document, repeat steps 5 through 9.

In both MS Word and Excel you go to the View Menu and select Header and Footer. It is simple to Delete any unwanted text from them.
In Word, In print layout view, you can quickly switch between the header or footer and the document text. Just double-click the dimmed header or footer or the dimmed document text.
To view a header or footer, switch to print layout view. To edit or format a header or footer, you need to display the header or footer you want.

In Word or Excel, go to View on the top Menu. Select Header and Footer. This shows a box (in dotted lines for Word) where you can click to insert yor cursor, then Delete. Click in the bottom box to delete Footer.
Then SAVE document.

open the excel spread sheet --go to insert-- find the header & footer symbol--click on it and edit as required.

this will set the head on every page till you remove it.


On the View menu, click Header and Footer to open the header or footer (header and footer: A header, which can consist of text or graphics, appears at the top of every page in a section. A footer appears at the bottom of every page. Headers and footers often contain page numbers, chapter titles, dates, and author names.) area on a page.

1. To create a header, enter text or graphics in the header area.
2. To create a footer, click Switch Between Header and Footer on the Header and Footer toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) to move to the footer area, and then enter text or graphics.
3. If necessary, format text by using buttons on the Formatting toolbar.
4. When you finish, click Close on the Header and Footer toolbar.

If are using Vista or Windows 7 operating system, go to VIEW at the top of the document you are going to print and in the drop down under VIEW select and click on the FOOTER & HEADER and click on it. Then when the Footer & Header page comes up DELET everything in both of them and then on the right of the Footer & Header click on CLOSE and it should take care of the problem.
This also applies to other Operating System’s.
Hope this helps, Bud

Are you using the Custom Footer option?

Click View>Header and Footer...>Custom Footer...

It should have &[PAGE] in the section that you want the Page# to appear. If it does not, click the section where you want it and then click on the icon that has the # sign on it. Click OK.

Thanks for using Fixya.

Click on view menu, then on header and footer. A toolbar will come over and try to look for a button "switch between header and footer" on the header and footer toolbar.
I hope the numbers disturbing you are down the means you switch to footer.
After switch to footer, the cursor will go down to those numbers disturbing you. You just delete them and everything will be perfect.

I've never had this problem, but if you hit "Alt-F#," you'll get "Reveal Codes" at the bottom of your screen. Then go to the first page of the document where the problem begins, locate the code for the footers and headers you don't want, and then delete those codes.

Another, probably simpler approach is to click "Insert" and on the drop down menu, click "Header/Footer." Then unselect whatever is dotted. That should get rid of the headers and footers. JS