Title Block in Excel

[pigsie]

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

 

[carlo]

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

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

 

[Bob Phillips]

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.

--
---
HTH

Bob

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