ExcelBanter - Can headers be repeated on different worksheets in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can headers be repeated on different worksheets in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/74867-can-headers-repeated-different-worksheets-excel.html)

Tom Reynolds

Can headers be repeated on different worksheets in excel?

JE McGimpsey

Can headers be repeated on different worksheets in excel?

Yes, group the sheets (select the left-most, shift-click the right-most)
before editing the header. Right-click a worksheet tab and choose
Ungroup before editing further, or else any changes will apply to all
sheets.

In article ,
Tom Reynolds <Tom wrote:

All times are GMT +1. The time now is 08:47 PM.