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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Brad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

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.
--
Regards |:>)
Bob Jones
[MVP] Office:Mac

"Brad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>