How do you you give your workheet a title, e.g. 'Prodect Sales' in the middle
then the cells below as usual?

Cherie;

Right click on the tab you wish to rename and select Rename. The words will
become "negatived" like a picture. Type the new name of the sheet.

God Bless

Frank Pytel

"Cherie" wrote:

How do you you give your workheet a title, e.g. 'Prodect Sales' in the middle
then the cells below as usual?

I'm not sure if this is what you are asking. But I think you might try this:
highlight row where you u wish to add title, go to format cells / alignment
/ text control/ merge cells

Hope it helps!


Frank Pytel wrote:
Cherie;

Right click on the tab you wish to rename and select Rename. The words will
become "negatived" like a picture. Type the new name of the sheet.

God Bless

Frank Pytel

How do you you give your workheet a title, e.g. 'Prodect Sales' in the middle
then the cells below as usual?

Hi Cherie

I read your question a little different to Frank.
Select a range of cells say A1:H1 then
FormatCellsAlignmentHorizontalCentre across selection
Enter your text in A1, and it will become centred across the range you chose
--
Regards
Roger Govier



"Cherie" wrote in message
...
How do you you give your workheet a title, e.g. 'Prodect Sales' in the
middle
then the cells below as usual?

Hi Roger
Thankyou so very much.

"Roger Govier" wrote:

Hi Cherie

I read your question a little different to Frank.
Select a range of cells say A1:H1 then
FormatCellsAlignmentHorizontalCentre across selection
Enter your text in A1, and it will become centred across the range you chose
--
Regards
Roger Govier



"Cherie" wrote in message
...
How do you you give your workheet a title, e.g. 'Prodect Sales' in the
middle
then the cells below as usual?

And another possibility. You may be looking for a header.
Go to ViewHeader and FooterView
Then on the Header/Footer Tab click on Custom Header

And just as an aside, as Frank said you can use Right ClickRename
on a sheet tab which can also be achieved by simply double clicking
on the sheet tab.

HTH
Martin


"Cherie" wrote in message
...
How do you you give your workheet a title, e.g. 'Prodect Sales' in the
middle
then the cells below as usual?