Thank you it was very helpful. You said that if it was helpful to click
the yes buttom, but i could not find it. Thanks again

ShaneDevenshire;3055644 Wrote:
Hi,

i think I follow what you want. This can be done in Excel 2007 but not
in
earlier versions. In 2007 when you have made a range into a table AND
you
scroll down far enought, within the table, and can't see the titles the

column letters will change to the Table Header titles. Once you can
see them
again, this feature turns off, as it does if you are outside the table.


In earlier versions the best you can do is Freeze Panes.

If this helps, please click the yes button
--
Thanks,
Shane Devenshire


"edwino2007" wrote:
-

Hi I am defining a table using Excel e.g where the headings are
regions,
customers, etc. How can I move the headings, regions, customers, etc,
and shown them on top of the columns instead of the A,B,C columns.
Thanks.




--
edwino2007
-




--
edwino2007