how do i create a table in excel 2003?

B

biff

I can do it in excel 2007.

I have a tab delimited text file that I import into Excel 2003. The fields
import correcly. Next I need to create a table for the data. If I go to the
Data menu and then select table, I am presented With a "Row input cell" and
"Column input cell". I have no idea what to input here. If I use Excel 2007
the same steps then ask me "What is the data for your table" and I then
select all the columns & rows with data. I tried selecting all the rows for
the "Row input cell" and all the columns for "Column input cell" but I get an
error that says "Input cell reference is not valid".

The reason I want to create a table is for sorting purposes.
 
B

BoniM

From the Menu bar - Data, List, Create List
They changed to calling it a table for '07...
 

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

Generating a Table of Results 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Table on Data menu 10
Excel 2003 - Data > Table 2
Help to create a macro 2
Excel formula question 2
force entry in cell "B" if entry made in cell "A" 1

Top