Hello

I have a file with sheets that have the same header. Each tab has specific
page setup formatting that I need to keep intact. I tried highlighting all
tabs and changing the header via page setup but the other page setup
formatting changed to the formatting of the first sheet.

Is there a way to add the header I would like to put on all tabs to the
header drop down menu on header/footer tab in page setup.

Thanks