how to repeat row in header

gsrikanth · #1 06-21-2012, 04:09 AM

Quote:

Originally Posted by macropod

I'd have thought 'rows to repeat at top' was fairly obvious. For example, $1:$5 will cause rows1-5 to appear on every page.

i page break come in even no it ok it print both side
but in odd no , print only one side back side it was blank

there is any option if no data at particular side remove header?

macropod · #2 06-27-2012, 08:01 PM

Quote:

Originally Posted by gsrikanth

i page break come in even no it ok it print both side
but in odd no , print only one side back side it was blank

there is any option if no data at particular side remove header?

No. Are you sure there aren't used rows in that range? Pressing Ctrl-End will take you to the last-used cell. Delete any unwanted rows & columns up and left from that cell.

gsrikanth · #3 06-27-2012, 10:14 PM

Quote:

Originally Posted by macropod

No. Are you sure there aren't used rows in that range? Pressing Ctrl-End will take you to the last-used cell. Delete any unwanted rows & columns up and left from that cell.

just preview my attachment

I insert a row empty to get page empty

in that i don't need header

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
i want to insert page break without repeat row on top	gsrikanth	Excel	0	05-24-2012 04:07 AM
How to get this header?	msvis	Word	1	12-04-2011 07:45 PM
Using fields to repeat data throughout a document	Brasada	Word	0	07-20-2010 02:37 PM
No Header Gap visible?	dr_mik	Word	0	11-25-2009 06:10 PM
Why do I get repeat mails after login 2 different machine?	shital	Outlook	2	02-15-2006 11:29 PM