How to copy headers/footers between worksheets

G

Guest

Can I copy headers/footers between worksheets in a workbook without copying
the entire sheet?
 
R

Ron de Bruin

Hi Bruce

Select all your sheets first (right click in a a sheet tab "select all sheets"
Add your header and footer
Ungroup the sheets(right click in a a sheet tab "ungroup sheets"
 
G

Guest

Thank you so much!!! I had over 60 worksheets that I needed to add the same
footer to and everyone was telling me it can't happen and that I'll need to
do it on each individual one.

Thank you so much for this quick and easy fix.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

transferring headers and footers 1
Copy Headers and Footers between wookbooks 1
page set-up 1
How to copy headers/footers across worksheets 5
Help with Headers and Footers 1
Headers & Footers _auto update info from a cell in the worksheet 4
Headers & Footers in Excel 1
Page Setup 1

Top