Defining a table in Excel

B

Brad

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
 
B

Bernard Liengme

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
 
C

CyberTaz

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.
 
Top