View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Defining a table

A, B, C, (or if you are running xl in R1C1 format, 1, 2, 3) is how excel
essentially works. You really can't. If you don't like it, you could always
go under Tools|Options, View tab, and uncheck Row & Column headers. (assuming
you are not using xl2007).
If you really are a new user, I don't recommend it, as your formulas require
Row and Column references.
If, as I suspect, the main thing you are concerned about is scrolling and
losing sight of your headers, then, click in cell A2, and go to menu
Window|Freeze Panes, and this will 'lock' row 1 at the top of the screen.
--
** John C **

"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