Insert workbook title in row A

[kennie]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I am creating a workbook that must be read and added to by others. The recipients will have all sorts of computers. Older versions of Excel on PCs do not have a Page Layout View, so some people cannot see the header on their screens.

Can I insert the title of the Workbook into Row A across columns A-D?

Thank you,
Kennie

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I am creating a workbook that must be read and added to by others. The
recipients will have all sorts of computers. Older versions of Excel on PCs do
not have a Page Layout View, so some people cannot see the header on their
screens.

Can I insert the title of the Workbook into Row A across columns A-D?

Thank you,
Kennie

Do you mean the workbook's file name that may change as people make changes
to it, or do you simply mean text that you type? If the former, enter this
formula in A1: =cell("filename"). If the Latter, just type what you want for
a title in A1. If this does not answer your question, post back here

 

[kennie]

Thanks Bob,
The title will not be changed by the recipient, but I want it to be across the top of the page, not just in A1. I have gotten as far as pasting a Word document as an object into row A, but I cannot get the vertical column separators to disappear. I have tried formating borders and they are pale, but they are still there. Any suggestions?

Kennie

 

[Bob Greenblatt]

Thanks Bob,
The title will not be changed by the recipient, but I want it to be across the
top of the page, not just in A1. I have gotten as far as pasting a Word
document as an object into row A, but I cannot get the vertical column
separators to disappear. I have tried formating borders and they are pale, but
they are still there. Any suggestions?

Kennie

You should be able to type what ever text you want in A1 and it wil flow
into B1, c1, etc. as needed. If you want it centered over several columns,
type it in C1 or D1 and format the text as centered. If neither of these
works for you, please try to explain in more detail what you are trying to
do and what Excel is doing/not doing.

 

[kennie]

Thanks. I finally got it. The key was that I had to merge the four cells and wrap the text. After that it worked just as you said it would.

Kennie