Make the same titles repeated in multiple sheets of a workbook


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.
 
Ad

Advertisements

M

muddan madhu

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
Macro for all Excel Workbooks to print to PDF 2
Similar Book to Book Code, one works other does not 11

Top