Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 7th 08, 06:42 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default Defining a table


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

  #2   Report Post  
Old November 7th 08, 08:12 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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

  #3   Report Post  
Old November 7th 08, 08:31 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1,805
Default Defining a table

Include the headers while selecting the data and creating the table...
Choose 'My table has headers'

"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

  #4   Report Post  
Old November 8th 08, 12:38 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default Defining a table

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

  #5   Report Post  
Old November 8th 08, 06:26 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default Defining a table


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


  #6   Report Post  
Old November 9th 08, 09:21 AM posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default Defining a table

The "Yes" buttons for rating responses are available in MS' webpages

For your posting, you could click this link to reach it in MS' webpages:
http://www.microsoft.com/communities...4-0ec16f69dc90

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---
"edwino2007" wrote in message
...

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with defining names [email protected] Excel Worksheet Functions 3 February 14th 08 09:34 AM
defining a name in a cell? [email protected] New Users to Excel 3 July 15th 07 08:50 AM
Defining fiscal month for pivot table Paul Excel Discussion (Misc queries) 1 February 16th 07 09:35 PM
Name Defining Chris Excel Discussion (Misc queries) 2 August 10th 06 03:06 PM
Defining Matt Excel Discussion (Misc queries) 1 July 26th 05 08:13 PM


All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017