Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

repeat a header on multiple worksheets 1

Status
Not open for further replies.

JTuc

Technical User
Joined
Sep 5, 2002
Messages
11
Location
US
I have a workbook with multiple worksheets inside of it. I want all of the worksheets to have the same header. Is there a quick and easy way to do this, without having to go into each worksheet and type in the header?
 
if u select the sheets using CTRL key and the left mouse button and then type in ur header, it will type in all the sheets
 
Thanks onedtent for your rapid response, it worked like a charm!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top