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.
 
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
How do you chart data from multiple sheets within a workbook? 3
Merge muliple sheets in multiple workbook below each other. 3
Copying cells and formula from closed workbook to all sheets in open workbook 0
Combine multiple sheets within workbook 1

Top