Defining a table in Excel

  • Thread starter Thread starter Brad
  • Start date Start date
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
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Turning Data into a Table 1
Access #Error & Excel Pivot 0
Excel 2007 graphs/charts automatically populate with new data 1
pivot table limitation? 3
VBA - retrieve data on last create named range from previous inserted named range 0
making an excel table visible for external data on pivot table 1
Turning a 3 column flat file into a "3D" Table 2

Back
Top