One header for all worksheets in workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an easy &/or quick way to make a common header for all worksheets in
a workbook?? We use workbooks w/monthly worksheets to track our employees
work & it would be nice to be able to change header information without
having to go to each individual worksheet.
 
Hi
just select all of your sheets (group them with holding down the cTRL
key while selecting them)
 
Thanks, Frank! That will save me a lot of time!

Frank Kabel said:
Hi
just select all of your sheets (group them with holding down the cTRL
key while selecting them)
Click to expand...
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
different header for different worksheets? 1
Header copy across workbooks 2
Find & Replace in Headers 5
Different headers, same footers on multiple worksheets 2
Inserting Columns Across Multiple Worksheets 4
add same header to entire workbook 3
Help on consolidate worksheets from different workbooks into one 2

Back
Top