Hi Mahreen, Follow the below mentioned procedure for the same. 1. go to the file menu 2. select page setup 3. click on sheet tab 4. there is option "Rows to repeat at top" click on that and give the range of required field 5. than come back by click on ok and print it.
*Unfeigned Regards Manoj S Negi "Miles & miles to go before I sleep"* *¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨) (¨`·.·´¨) `·.¸(¨`·.·´¨)¸.·´ `·.¸.·«*:·. .·:* *:·. *«*:·. .·:* *:·. * On Thu, Apr 9, 2009 at 12:38 PM, Mahreen Ellahi <mahreen.a...@googlemail.com > wrote: > I have few cells in excel worksheet that I want to show as header in print > copy. Can any one tell me how to select those cells to show as print header. > > > Regards > Mahreen > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
