Title Block in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pigsie - 14 Nov 2007 00:55 GMT

Hi All,

I would like to add a title block to all excel documents created for
document configuration management purposes; i.e. Document Title,
Document No., Owner, Date, Revision No. etc. What is the best way to
add a title block, to every spreadsheet without affecting the freedom
of using the cells how you want underneath the Title Block.

Any help is appreciated. Regards

Reply to this Message

carlo - 14 Nov 2007 05:03 GMT

> Hi All,
>
[quoted text clipped - 5 lines]
>
> Any help is appreciated. Regards

Did you already try View --> Header and Footer
This should work fine. If you want to apply that
to more than one worksheet, select them by
holding the Ctrl-key

hth

Carlo

Reply to this Message

Bob Phillips - 14 Nov 2007 11:38 GMT

Do you mean in the spreadsheet view? If so, select a cell one row below and
one column to the right of where you want, and goto Windows>Freeze Panes.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi All,
>
[quoted text clipped - 5 lines]
>
> Any help is appreciated. Regards

Reply to this Message