Print_Title

[sgmpatnaik]

Sir I just create the Print Title in Define Names of Formula but it's not working how can i use that formula


i mean Heading of the First Sheet page one automatically it's continues for the next page


Ex: - 'Sheet1'!$A:$J,'Sheet1'!$1:3$


Kindly suggest

 

[Hui]

SP


The Named Range "Print Area" only defines the print Area, it doesn't define the Header Rows


I'd also be careful as defining a Print Area as A:J may end up printing out thousands of pages of nothing.


The Named Formula for a Print area is Called : Print_Area


Define the Title and Column headers using the Print Titles or Page Setup menus

 

[sgmpatnaik]

Thank Q Sir just little bit miss understanding from me