S
squeaky
I was trying to adjust my "header" row so that the column headings will print
on all pages, but one column's heading will be different on pages 2 and
above.
I thought perhaps I could making that cell's contents an "IF" function -
basically, IF(page number>1, value1, value2). But I cannot figure out how to
reference the current page number as an argument in the function. Seems like
I would be able to do this in Word (something like "insert field"), but not
in Excel. In excel, they allow you to insert a date and time function into a
cell, but not page number as far as I can tell. Thanks.
on all pages, but one column's heading will be different on pages 2 and
above.
I thought perhaps I could making that cell's contents an "IF" function -
basically, IF(page number>1, value1, value2). But I cannot figure out how to
reference the current page number as an argument in the function. Seems like
I would be able to do this in Word (something like "insert field"), but not
in Excel. In excel, they allow you to insert a date and time function into a
cell, but not page number as far as I can tell. Thanks.