Make the same titles repeated in multiple sheets of a workbook

  • Thread starter Thread starter Subodh
  • Start date Start date
S

Subodh

I want to repeat the same text in the titles across multiple sheets
of a workbook. I want to print titles by repeating the same text
on the top of all sheets of the workbook. ie. i need to repeat the
Rows 1:3 of Sheet 1
on all pages printed of sheet1 as well as other sheets in the
workbook.
Any help would be appreciated.
Thanks in advance.
 
assume you have header in sheet1

copy that header, now select sheet2, sheet3 using ctrl or shift
( first and last sheet ) etc..

in sheet2 paste it. same will be pasted in all the selected sheets.
 

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

Repeat the titles across multiple sheets of a workbook. 6
To get the same header,footer and sheet titles across multiple sheetsof a workbook. 1
Sheet and workbook code: All sheets should have row 1 to 5 of Sheet1to be repeated at top 3
Rows columns to repeat while printing in a workbook 1
Sound repeats unending until closing workbook 2
All sheets in workbook have same rows to repeat at top 1
How do you chart data from multiple sheets within a workbook? 3
Macro for all Excel Workbooks to print to PDF 2

Back
Top