Repeating Rows and Columns on every page
I have a problem formatting my report in the way I would like to.
I want to repeat the top 10 rows and the first 4 columns of my report on each page when I print it (therefore the text I want repeated makes an upside down L shape) I know that I need to do the following: Rows to repeat: $1:$10 Columns to repeat: $A:$D However, the report 'headings' in the first 10 rows include merged cells (e.g I merge 6A - 6T). This causes a problem in the printed version of the report, as any header text which is not 'alligned' with columns A-D will not appear on any page other than the first page. Only the text alligned with columns A-D is repeted on each page - the other text that I want to see from the first 10 rows is not vissible Is it possible to get round this without using the actual 'Headers' facility? Thanks in advance |
All times are GMT +1. The time now is 07:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com