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
|
|||
|
|||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec
I need a way to fix a print problem. When I go into File - Page Setup, and I
choose which rows to repeat at the top ($1:$5) and select which columns to repeat at left ($A:$A), the rows at the top never print completely on pages 2 through the end. Only on the first page can I see the entire title and subtitle. On the remaining pages they get cut off where Column B would begin. Can I fix this? |
#2
|
|||
|
|||
Hi
Select only the rows to repeat at the top, and see if that solves your problem -- ve_2nd_at. Randburg, Gauteng, South Africa "unibaby" wrote: I need a way to fix a print problem. When I go into File - Page Setup, and I choose which rows to repeat at the top ($1:$5) and select which columns to repeat at left ($A:$A), the rows at the top never print completely on pages 2 through the end. Only on the first page can I see the entire title and subtitle. On the remaining pages they get cut off where Column B would begin. Can I fix this? |
#3
|
|||
|
|||
It does, but then how do I get Column A to also repeat on every page? Its
important because it is the identifier for each individual row which contains columns and columns of data. "Kassie" wrote: Hi Select only the rows to repeat at the top, and see if that solves your problem -- ve_2nd_at. Randburg, Gauteng, South Africa "unibaby" wrote: I need a way to fix a print problem. When I go into File - Page Setup, and I choose which rows to repeat at the top ($1:$5) and select which columns to repeat at left ($A:$A), the rows at the top never print completely on pages 2 through the end. Only on the first page can I see the entire title and subtitle. On the remaining pages they get cut off where Column B would begin. Can I fix this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | foofoo | General Discussion | 1 | April 2nd, 2005 12:02 AM |
Repeat Records - Please Help? | Repeat records | Running & Setting Up Queries | 9 | September 29th, 2004 05:29 PM |
Need to switch columns with rows | Carol Ebbinghouse | Worksheet Functions | 5 | September 14th, 2004 04:32 PM |
set max columns and rows in a worksheet | Joshua | Worksheet Functions | 3 | September 5th, 2004 10:27 AM |
csv-file-lines back to excel rows and columns - HOW? | rosalia | General Discussion | 1 | August 17th, 2004 11:47 PM |