Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
make first few rows print on every page? | New Users to Excel | |||
interchange columns with rows | Excel Discussion (Misc queries) |