Excel Add in to have repeated header as an option in settings

Currently paste view, the header in row or column are omitted if is a repeated value understand this looks neat however in certain cases ( customer ask) that to show this repeated header so when they scroll right or scroll down they still now which element they are looking at.