Title Block in Excel

  • Thread starter Thread starter pigsie
  • Start date Start date
P

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
 
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
Click to expand...

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
 
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)
 
Back
Top