Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11
Default Where can I find the syntax and semantics for expressions in Excel 2003 headers and footers?

Where can I find the syntax and semantics for expressions available
for use in page headers/footers?

The Excel 2003 built in "Help" says that you can use the predefined
buttons or type a few "&[{functionname}]" functions in the
header or footer. (The functions are, &[Page], &[Pages], &[Date]
and a few more.),

However, it doesn't mention that you can use constructs such as
&[Page]-2&
to get 2 less than the page number.

Where can I find the complete syntax and semantics for what is
permitted?

Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,276
Default Where can I find the syntax and semantics for expressions in Excel

Hi Mark
Take a look at

http://www.journalofaccountancy.com/...ersinExcel.htm

if this helps please click yes, thanks

"Mark F" wrote:

Where can I find the syntax and semantics for expressions available
for use in page headers/footers?

The Excel 2003 built in "Help" says that you can use the predefined
buttons or type a few "&[{functionname}]" functions in the
header or footer. (The functions are, &[Page], &[Pages], &[Date]
and a few more.),

However, it doesn't mention that you can use constructs such as
&[Page]-2&
to get 2 less than the page number.

Where can I find the complete syntax and semantics for what is
permitted?

Thank you.

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
Excel 2003 Too many inherited custom headers and footers Confused Excel Discussion (Misc queries) 0 December 7th 07 05:39 PM
Delete automatic headers/footers in dropdown lists in Excel 2003 MJ Excel Discussion (Misc queries) 0 November 8th 07 06:26 PM
Excel XP/2003 - Fields in Headers/Footers... Birmangirl Setting up and Configuration of Excel 3 November 8th 05 04:21 PM
Protecting Headers & Footers in Excel 2003 LondonLion Excel Discussion (Misc queries) 1 September 22nd 05 01:53 PM
Excel Headers and Footers??? Katie Excel Discussion (Misc queries) 7 April 27th 05 05:48 PM


All times are GMT +1. The time now is 05:52 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"