how to repeat row in header

gsrikanth · #1 06-20-2012, 11:14 PM

little problem in how to repeat row in header

in empty page are header row repeated (i dont want in empty page)

macropod · #2 06-21-2012, 02:31 AM

You can either add a header to the worksheet (via View|Header & Footer|Header/Footer) or tell Excel to repeat certain rows and columns (via View|Header & Footer|Sheet) - or you can do both.

gsrikanth · #3 06-21-2012, 03:55 AM

Quote:

Originally Posted by macropod

You can either add a header to the worksheet (via View|Header & Footer|Header/Footer) or tell Excel to repeat certain rows and columns (via View|Header & Footer|Sheet) - or you can do both.

where we will give certain rows (in print area) "is it right"

it is not possible to give to wholesheet

macropod · #4 06-21-2012, 03:59 AM

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.

gsrikanth · #5 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 · #6 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 · #7 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

macropod · #8 06-27-2012, 10:17 PM

You can't suppress the header that way.

gsrikanth · #9 06-27-2012, 10:22 PM

Quote:

Originally Posted by macropod

You can't suppress the header that way.

any option to above
i need first column left(a1,10) changing it will start in new page.

macropod · #10 06-28-2012, 12:51 AM

What you could do is submit separate print jobs, such that each range will either have content or be blank. Try the following macro:

Code:

Sub PrintReport()
Dim RwStart As Long, RwEnd As Long, RwLast As Long, StrVal As String
With ActiveSheet
  RwLast = .Cells.SpecialCells(xlCellTypeLastCell).Row + 1
  RwStart = 2
  StrVal = Left(.Cells(RwStart, 2).Value, 10)
  For RwEnd = RwStart To RwLast
    If Left(.Cells(RwEnd, 2).Value, 10) <> StrVal Then
      .Range("A" & RwStart & ":I" & RwEnd - 1).Printout
      RwStart = RwEnd
      StrVal = Left(.Cells(RwStart, 2).Value, 10)
    End If
  Next
End With
End Sub

Note: with this code you do not need any page breaks - your 'blank' pages should be deleted and your manual page breaks can be deleted also.

gsrikanth · #11 06-28-2012, 02:31 AM

great thanks

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