| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create a table in excel 2003?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i create a table in excel 2003?
From the Menu bar - Data, List, Create List
They changed to calling it a table for '07... "biff" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i create a table in excel 2003?
Thank you BoniM. That solved the issue and saved me some frustration.
"BoniM" wrote: From the Menu bar - Data, List, Create List They changed to calling it a table for '07... "biff" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i create a table in excel 2003?
Always good to fight frustration - you're welcome!
Happy sorting... "biff" wrote: Thank you BoniM. That solved the issue and saved me some frustration. "BoniM" wrote: From the Menu bar - Data, List, Create List They changed to calling it a table for '07... "biff" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a league table in excel 2003 | Excel Discussion (Misc queries) | |||
| How do I create a dashboard using Excel 2003? | Charts and Charting in Excel | |||
| Pivot Table - Create new file with ONLY certain data - Excel 2003 | Excel Worksheet Functions | |||
| Create new excel table with filtered records from another table | Excel Worksheet Functions | |||
| create pivot table from excel table | Excel Worksheet Functions | |||
Hybrid Mode
