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 titles across multiple sheets of a workbook 0
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
How to make repeating drop-down lists? 2
Print order of TriFold - Publisher 365 0
Sheet and workbook code: All sheets should have row 1 to 5 of Sheet1to be repeated at top 3
Space at end of multi page list to accommodate new entries 1
Embed the same Excel multiple times 0

Top