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.
 
Back
Top