View Single Post
  #1   Report Post  
divya nila divya nila is offline
Junior Member
 
Posts: 3
Default How to determine Last row of a Page in Excel

Hi,

I want to add Page border (for four sides) around each page in the spreadsheet of excel. My excel is having multipages in one spreadsheet and it is having nearly 6 spreadsheets. I have used PageBreaks to determine last row of a page but the pagebreak is 0 if i have only one page in a spreadsheet. So i want to know how to determine the last row of a page.

Thanks in Advance.