Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2012, 11:14 PM
gsrikanth gsrikanth is offline how to repeat row in header Windows XP how to repeat row in header Office XP
Competent Performer
how to repeat row in header
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default how to repeat row in header

little problem in how to repeat row in header



in empty page are header row repeated (i dont want in empty page)
Reply With Quote
  #2  
Old 06-21-2012, 02:31 AM
macropod's Avatar
macropod macropod is offline how to repeat row in header Windows 7 64bit how to repeat row in header Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-21-2012, 03:55 AM
gsrikanth gsrikanth is offline how to repeat row in header Windows XP how to repeat row in header Office XP
Competent Performer
how to repeat row in header
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Reply With Quote
  #4  
Old 06-21-2012, 03:59 AM
macropod's Avatar
macropod macropod is offline how to repeat row in header Windows 7 64bit how to repeat row in header Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 06-21-2012, 04:09 AM
gsrikanth gsrikanth is offline how to repeat row in header Windows XP how to repeat row in header Office XP
Competent Performer
how to repeat row in header
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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?
Reply With Quote
  #6  
Old 06-27-2012, 08:01 PM
macropod's Avatar
macropod macropod is offline how to repeat row in header Windows 7 64bit how to repeat row in header Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by gsrikanth View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 06-27-2012, 10:14 PM
gsrikanth gsrikanth is offline how to repeat row in header Windows XP how to repeat row in header Office XP
Competent Performer
how to repeat row in header
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Attached Files
File Type: xlsx UPLOAD.xlsx (354.8 KB, 8 views)
Reply With Quote
  #8  
Old 06-27-2012, 10:17 PM
macropod's Avatar
macropod macropod is offline how to repeat row in header Windows 7 64bit how to repeat row in header Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You can't suppress the header that way.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 06-27-2012, 10:22 PM
gsrikanth gsrikanth is offline how to repeat row in header Windows XP how to repeat row in header Office XP
Competent Performer
how to repeat row in header
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Reply With Quote
  #10  
Old 06-28-2012, 12:51 AM
macropod's Avatar
macropod macropod is offline how to repeat row in header Windows 7 64bit how to repeat row in header Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 06-28-2012, 02:31 AM
gsrikanth gsrikanth is offline how to repeat row in header Windows XP how to repeat row in header Office XP
Competent Performer
how to repeat row in header
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

great thanks
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft