Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Limit the rows in a column that repeat on the second page?

File, Page set-up enables one to detail the columns that can be repeated as
row headings on subsequent pages. If one is using a few columns that need to
be repeated but has notes further down the page that are to be printed on the
first page but not on following pages how is that specified?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,203
Default Limit the rows in a column that repeat on the second page?

I'm not sure I fully understand. Only the rows you select to be repeated
will be repeated, all others are just printed in sequence. So if your column
headers are in rows 1 and 2, you instruct it to repeat/print rows 1 and 2 on
all sheets, the rows after 2 will just print in sequence.

You may be able to achieve what you want simply by placing the notes you
want to appear on the first page only in a few rows that will print on the
first page. You can experiment a little with Print Preview to see where the
page is going to get cut off, then insert a few rows ahead of that point and
put the notes in those rows?

This might cause some other issues, such as breaking up the flow of any
formulas that are filled down the worksheet, but you could repair those after
getting the notes laid out like you need them.

Another option is to repeat the notes on every page using a custom Footer.
Use View | Headers and Footers and choose Custom Footer. The footer is
divided into 3 sections, type and format what you want into them (you don't
have to use them all) and whatever is in the footer will appear on every
printed page from that sheet.

"Bill G" wrote:

File, Page set-up enables one to detail the columns that can be repeated as
row headings on subsequent pages. If one is using a few columns that need to
be repeated but has notes further down the page that are to be printed on the
first page but not on following pages how is that specified?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to repeat multiple rows as a header - each page of worksheet? laurandc Excel Worksheet Functions 1 August 17th 06 03:03 PM
Rows to repeat on each page jpreman Excel Worksheet Functions 6 August 16th 06 03:36 PM
repeat a formula same column same number of rows apart steveo Excel Discussion (Misc queries) 2 July 9th 06 04:34 AM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Repeat 6 rows, 1 column on many pages in Excel, 6th row cut off? Pelgy Excel Discussion (Misc queries) 0 December 7th 05 08:45 PM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"