If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Repeating Rows and Columns on each page of print out | BruceM | General Discussion | 1 | July 6th, 2005 12:28 PM |
How to Join two tables and avoid multiple rows, and get repeating columns instead! | JH | General Discussion | 2 | April 25th, 2005 01:32 AM |
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | foofoo | General Discussion | 1 | April 2nd, 2005 12:02 AM |
print spreadsheet columns as rows down the page in excel | 95YJ | General Discussion | 3 | October 19th, 2004 02:20 AM |
Repeating Rows and Columns | Jonathan Rynd | Worksheet Functions | 0 | January 29th, 2004 09:50 PM |