Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 155
Default "page number" function as an argument

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 number1, 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text "comparison" operator for "contains" used in an "IF" Function Pawaso Excel Worksheet Functions 4 April 4th 23 11:35 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
What Function Should I Use. Is this a "What If" Type of Argument? Scott R[_2_] Excel Worksheet Functions 3 February 9th 08 05:28 PM
how to use "if" logical argument to format/copy some pic. in cell Ali Excel Worksheet Functions 0 April 16th 07 01:46 PM
How do I lighten the word "Page" (and number) in Page Break View? ExcelJockey Excel Discussion (Misc queries) 0 June 29th 06 07:26 PM


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"