How to remove header/footer across multiple sheets/tabs in a workbook?

**C.j.** · 06-15-2012, 11:01 AM

I have a workbook that I am editing, I need to remove the footer from each sheet (tab at the bottom) right now I have to click on each sheet indivdually and remove it, is there a way to do them all at the same time.

**TMS** · 06-16-2012, 04:52 AM

You could do it with a macro. You'd loop through each of the sheets and clear the footer areas ... at least, in theory.

Do you want a macro?

Regards, TMS

**martindwilson** · 06-16-2012, 05:09 AM

footer is a print thing, but you can remove all headers/footers at once by selecting all sheets then print preview/page set up change whatever is set to none

**Poornima M** · 06-16-2012, 05:26 AM

Excel 2007:
Hold down the Shift key and click on the first and last sheet tab
Click on PAGE LAYOUT tab
In the PAGE SETUP box, click on the small arrow button on the bottom right
Select HEADER/FOOTER tab
Set FOOTER to None
Press OK

**TMS** · 06-16-2012, 05:37 AM

@Martin/Poornima M: absolutely

... I somehow thought I'd had problems doing that. Must be something else, perhaps related ... must have been the Print Area and Rows/Columns to repeat.

Regards, TMS