Menu

Better support for dynamic content within headers and footers

Search this Thread

#1

Report Post

Frank Kabel

Posts: n/a

Default

Hi Scott
email to

--
Regards
Frank Kabel
Frankfurt, Germany
"Anvil Scott" <Anvil schrieb im Newsbeitrag
...
One of the major limitations that I find there is with Excel is the
ability
to display dynamic content within headers and footers. Specifically,
without
adding VBA code, there is no way to place anything in the headers/footers
except for static text, the page number, the number of pages, date (in a
standard format), time (in a standard format), file name, sheet name, and
graphics.

For starters, I would like to see the following new functionality:

- The ability to specify different ways of formatting dates and times. A
good way to do this would be similar to how different formats are used
with
date/time fields in Word. For example, you would be able to specify
&[Date
"d MMMM yyyy"]

- The ability to specify data from a worksheet cell/variable. For
example,
you could specify &[Cell Sheet2!B12] to display the contents of cell B12
on
Sheet2

Ideally, I would like to see the ability to put anything that you can put
into a cell into each of the Left, Center, and Right sections of the
header
and the footer.

-- Scott

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Headers / footers in Excel	Airbags	Excel Discussion (Misc queries)	2	December 16th 04 07:21 PM

All times are GMT +1. The time now is 07:44 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement