Page number from cell

May 6, 2013 at 8:40 AM
Is it possible to determine which print page a given cell is on?

I would like to print table headers on every page. (I do not want to use 'Print Titles' Excel feature, because I would like to customize the titles on every page)

My spreadsheet is "one printer page" width and usually contains 34 rows / page, so most of the time I know when 'I am on a new page'. But some cells have word wrap on, so they consumes multiple rows.

Should I count the height of rows? Any idea?

Thank you very much!