THANK YOU!!! I have been trying to figure a way to do this for months.

"AK" wrote:

right click the a worksheet tab and select "Select All Sheets" (this will
highlight all the worsheets) then do the normal Page setup process


"Jim" wrote:

I have an existing workbook that I want to add headers/footers to every
worksheet? any easy way to do this?