To-days date in Header or Footer - Excel 2000


A

Abay

Hello,

I would like to-days date to display in the Header or Footer of a
spreadsheet each time it is printed. I know you can use =TODAY() in the
body of a worksheet and wonder if there is a way to use it in the header or
footer.

Excuse my ignorance .. as you can see I am not a expert in Excel .. some
help would be much appreciated.

Abay
 
Ad

Advertisements

S

Stan Brown

Hello,

I would like to-days date to display in the Header or Footer of a
spreadsheet each time it is printed. I know you can use =TODAY() in the
body of a worksheet and wonder if there is a way to use it in the header or
footer.

Excuse my ignorance .. as you can see I am not a expert in Excel .. some
help would be much appreciated.

Click View | Header and Footer.

On the dialog box, click Custom Header or Custom Footer.

You get a second dialog with a left, center, and right section. Click
into the one of those where you want the date, then little calendar
icon *or* just type
&[Date]
 
A

Abay

Thank you so much and apologies for I should have thought of that myself ...
Your help is much appreciated.

Abay
Stan Brown said:
Hello,

I would like to-days date to display in the Header or Footer of a
spreadsheet each time it is printed. I know you can use =TODAY() in the
body of a worksheet and wonder if there is a way to use it in the header
or
footer.

Excuse my ignorance .. as you can see I am not a expert in Excel .. some
help would be much appreciated.

Click View | Header and Footer.

On the dialog box, click Custom Header or Custom Footer.

You get a second dialog with a left, center, and right section. Click
into the one of those where you want the date, then little calendar
icon *or* just type
&[Date]
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top