Defining a table in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 08 Nov 2006 16:57 GMT

I have column headings for several columns of data that I'd like to treat as
an Excel Table, not a pivot table, just a standard Excel table. What steps
does one take to define a block of data as a table? Is it done by simply
naming it? My thanks for any assistance here. Brad

Reply to this Message

Bernard Liengme - 08 Nov 2006 17:10 GMT

If you Excel 2003 you can make a range into an Excel LIST (it will be called
'table' in Excel 2007). Select the range with headers; use Data | List ->
Create List
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I have column headings for several columns of data that I'd like to treat
>as an Excel Table, not a pivot table, just a standard Excel table. What
>steps does one take to define a block of data as a table? Is it done by
>simply naming it? My thanks for any assistance here. Brad

Reply to this Message

CyberTaz - 08 Nov 2006 17:54 GMT

You actually don't have to do anything more. As long as the data is in
consecutive columns, captions (field names) at the top & the records
consecutively listed beginning on the first row below the captions (no
'subtotals' or copies of captions, etc.) XL will recognize the range as long
as your active cell is anywhere within it. The routine necessity of
"Defining" a data range went away many versions ago :)

You can name the range of define a "List", but neither *has* to be done for
most features to be effective.

Signature

Regards |:>)
Bob Jones
[MVP] Office:Mac

Reply to this Message

Rate this thread: