ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Table on Data menu (https://www.excelbanter.com/excel-discussion-misc-queries/179000-table-data-menu.html)

Lauren

Table on Data menu
 
I am in a class that is using the 2003 Excel book, but I'm using 2007, and
I'm having trouble finding the Table that used to be on the Data menu. I
have to insert something in the column input cell. If anyone can direct me,
it is greatly appreciated!

Roger Govier[_3_]

Table on Data menu
 
Hi Lauren

DataList from XL2003 has been replaced in XL2007 with
Insert tabTable

--
Regards
Roger Govier

"Lauren" wrote in message
...
I am in a class that is using the 2003 Excel book, but I'm using 2007, and
I'm having trouble finding the Table that used to be on the Data menu. I
have to insert something in the column input cell. If anyone can direct
me,
it is greatly appreciated!



Lauren

Table on Data menu
 
The book is showing: DataTable
I am looking for the Table command. I guess that I should have been more
specific, but I'm not sure how to be since this is all so new to me and I'm
trying to make things harder by working at home! Hope you can get back to me
with more info, because I do appricate it! I'm taking this class to try to
learn, but I'm getting more confused!

"Roger Govier" wrote:

Hi Lauren

DataList from XL2003 has been replaced in XL2007 with
Insert tabTable

--
Regards
Roger Govier

"Lauren" wrote in message
...
I am in a class that is using the 2003 Excel book, but I'm using 2007, and
I'm having trouble finding the Table that used to be on the Data menu. I
have to insert something in the column input cell. If anyone can direct
me,
it is greatly appreciated!



Dave Peterson

Table on Data menu
 
Roger wasn't lying.

xl2003's Data|List has been removed in xl2007.


Lauren wrote:

The book is showing: DataTable
I am looking for the Table command. I guess that I should have been more
specific, but I'm not sure how to be since this is all so new to me and I'm
trying to make things harder by working at home! Hope you can get back to me
with more info, because I do appricate it! I'm taking this class to try to
learn, but I'm getting more confused!

"Roger Govier" wrote:

Hi Lauren

DataList from XL2003 has been replaced in XL2007 with
Insert tabTable

--
Regards
Roger Govier

"Lauren" wrote in message
...
I am in a class that is using the 2003 Excel book, but I'm using 2007, and
I'm having trouble finding the Table that used to be on the Data menu. I
have to insert something in the column input cell. If anyone can direct
me,
it is greatly appreciated!



--

Dave Peterson

Lauren

Table on Data menu
 
I know that he is not lying but there has got to be a way for me to tell it
to define a data table even in 2007...it is just going to take 15 steps
instead of 2, just like shading used to take 2 and now take many more than
that.


"Dave Peterson" wrote:

Roger wasn't lying.

xl2003's Data|List has been removed in xl2007.


Lauren wrote:

The book is showing: DataTable
I am looking for the Table command. I guess that I should have been more
specific, but I'm not sure how to be since this is all so new to me and I'm
trying to make things harder by working at home! Hope you can get back to me
with more info, because I do appricate it! I'm taking this class to try to
learn, but I'm getting more confused!

"Roger Govier" wrote:

Hi Lauren

DataList from XL2003 has been replaced in XL2007 with
Insert tabTable

--
Regards
Roger Govier

"Lauren" wrote in message
...
I am in a class that is using the 2003 Excel book, but I'm using 2007, and
I'm having trouble finding the Table that used to be on the Data menu. I
have to insert something in the column input cell. If anyone can direct
me,
it is greatly appreciated!


--

Dave Peterson


Lauren

Table on Data menu
 
and I'm looking for datatable NOT datalist

"Dave Peterson" wrote:

Roger wasn't lying.

xl2003's Data|List has been removed in xl2007.


Lauren wrote:

The book is showing: DataTable
I am looking for the Table command. I guess that I should have been more
specific, but I'm not sure how to be since this is all so new to me and I'm
trying to make things harder by working at home! Hope you can get back to me
with more info, because I do appricate it! I'm taking this class to try to
learn, but I'm getting more confused!

"Roger Govier" wrote:

Hi Lauren

DataList from XL2003 has been replaced in XL2007 with
Insert tabTable

--
Regards
Roger Govier

"Lauren" wrote in message
...
I am in a class that is using the 2003 Excel book, but I'm using 2007, and
I'm having trouble finding the Table that used to be on the Data menu. I
have to insert something in the column input cell. If anyone can direct
me,
it is greatly appreciated!


--

Dave Peterson


Dave Peterson

Table on Data menu
 
I'm going to stop listening to Roger!

You can customize the QAT (Quick Access Toolbar)

Rightclick on the QAT
Choose Customize Quick Access Toolbar
Choose All commands
Add "Data Table" to the QAT.



Lauren wrote:

I know that he is not lying but there has got to be a way for me to tell it
to define a data table even in 2007...it is just going to take 15 steps
instead of 2, just like shading used to take 2 and now take many more than
that.

"Dave Peterson" wrote:

Roger wasn't lying.

xl2003's Data|List has been removed in xl2007.


Lauren wrote:

The book is showing: DataTable
I am looking for the Table command. I guess that I should have been more
specific, but I'm not sure how to be since this is all so new to me and I'm
trying to make things harder by working at home! Hope you can get back to me
with more info, because I do appricate it! I'm taking this class to try to
learn, but I'm getting more confused!

"Roger Govier" wrote:

Hi Lauren

DataList from XL2003 has been replaced in XL2007 with
Insert tabTable

--
Regards
Roger Govier

"Lauren" wrote in message
...
I am in a class that is using the 2003 Excel book, but I'm using 2007, and
I'm having trouble finding the Table that used to be on the Data menu. I
have to insert something in the column input cell. If anyone can direct
me,
it is greatly appreciated!


--

Dave Peterson


--

Dave Peterson

Jim Rech[_2_]

Table on Data menu
 
Data Table is found he Data tab - Data Tools group - What-If Analysis
menu.

--
Jim
"Dave Peterson" wrote in message
...
| I'm going to stop listening to Roger!
|
| You can customize the QAT (Quick Access Toolbar)
|
| Rightclick on the QAT
| Choose Customize Quick Access Toolbar
| Choose All commands
| Add "Data Table" to the QAT.
|
|
|
| Lauren wrote:
|
| I know that he is not lying but there has got to be a way for me to tell
it
| to define a data table even in 2007...it is just going to take 15 steps
| instead of 2, just like shading used to take 2 and now take many more
than
| that.
|
| "Dave Peterson" wrote:
|
| Roger wasn't lying.
|
| xl2003's Data|List has been removed in xl2007.
|
|
| Lauren wrote:
|
| The book is showing: DataTable
| I am looking for the Table command. I guess that I should have been
more
| specific, but I'm not sure how to be since this is all so new to me
and I'm
| trying to make things harder by working at home! Hope you can get
back to me
| with more info, because I do appricate it! I'm taking this class to
try to
| learn, but I'm getting more confused!
|
| "Roger Govier" wrote:
|
| Hi Lauren
|
| DataList from XL2003 has been replaced in XL2007 with
| Insert tabTable
|
| --
| Regards
| Roger Govier
|
| "Lauren" wrote in message
| ...
| I am in a class that is using the 2003 Excel book, but I'm using
2007, and
| I'm having trouble finding the Table that used to be on the Data
menu. I
| have to insert something in the column input cell. If anyone
can direct
| me,
| it is greatly appreciated!
|
|
| --
|
| Dave Peterson
|
|
| --
|
| Dave Peterson



Lauren

Table on Data menu
 
That worked..Thanks so much!!!

"Dave Peterson" wrote:

I'm going to stop listening to Roger!

You can customize the QAT (Quick Access Toolbar)

Rightclick on the QAT
Choose Customize Quick Access Toolbar
Choose All commands
Add "Data Table" to the QAT.



Lauren wrote:

I know that he is not lying but there has got to be a way for me to tell it
to define a data table even in 2007...it is just going to take 15 steps
instead of 2, just like shading used to take 2 and now take many more than
that.

"Dave Peterson" wrote:

Roger wasn't lying.

xl2003's Data|List has been removed in xl2007.


Lauren wrote:

The book is showing: DataTable
I am looking for the Table command. I guess that I should have been more
specific, but I'm not sure how to be since this is all so new to me and I'm
trying to make things harder by working at home! Hope you can get back to me
with more info, because I do appricate it! I'm taking this class to try to
learn, but I'm getting more confused!

"Roger Govier" wrote:

Hi Lauren

DataList from XL2003 has been replaced in XL2007 with
Insert tabTable

--
Regards
Roger Govier

"Lauren" wrote in message
...
I am in a class that is using the 2003 Excel book, but I'm using 2007, and
I'm having trouble finding the Table that used to be on the Data menu. I
have to insert something in the column input cell. If anyone can direct
me,
it is greatly appreciated!


--

Dave Peterson


--

Dave Peterson


Dave Peterson

Table on Data menu
 
I searched and searched and ....

Stupid new stuff and old brain!

Jim Rech wrote:

Data Table is found he Data tab - Data Tools group - What-If Analysis
menu.

--
Jim
"Dave Peterson" wrote in message
...
| I'm going to stop listening to Roger!
|
| You can customize the QAT (Quick Access Toolbar)
|
| Rightclick on the QAT
| Choose Customize Quick Access Toolbar
| Choose All commands
| Add "Data Table" to the QAT.
|
|
|
| Lauren wrote:
|
| I know that he is not lying but there has got to be a way for me to tell
it
| to define a data table even in 2007...it is just going to take 15 steps
| instead of 2, just like shading used to take 2 and now take many more
than
| that.
|
| "Dave Peterson" wrote:
|
| Roger wasn't lying.
|
| xl2003's Data|List has been removed in xl2007.
|
|
| Lauren wrote:
|
| The book is showing: DataTable
| I am looking for the Table command. I guess that I should have been
more
| specific, but I'm not sure how to be since this is all so new to me
and I'm
| trying to make things harder by working at home! Hope you can get
back to me
| with more info, because I do appricate it! I'm taking this class to
try to
| learn, but I'm getting more confused!
|
| "Roger Govier" wrote:
|
| Hi Lauren
|
| DataList from XL2003 has been replaced in XL2007 with
| Insert tabTable
|
| --
| Regards
| Roger Govier
|
| "Lauren" wrote in message
| ...
| I am in a class that is using the 2003 Excel book, but I'm using
2007, and
| I'm having trouble finding the Table that used to be on the Data
menu. I
| have to insert something in the column input cell. If anyone
can direct
| me,
| it is greatly appreciated!
|
|
| --
|
| Dave Peterson
|
|
| --
|
| Dave Peterson


--

Dave Peterson

Roger Govier[_3_]

Table on Data menu
 
Lauren

My sincere apologies, I had totally misinterpreted what you were asking for.
As Jim pointed out, Data Table is part of the What If section on the Data
Tab.

--
Regards
Roger Govier

"Lauren" wrote in message
...
and I'm looking for datatable NOT datalist

"Dave Peterson" wrote:

Roger wasn't lying.

xl2003's Data|List has been removed in xl2007.


Lauren wrote:

The book is showing: DataTable
I am looking for the Table command. I guess that I should have been
more
specific, but I'm not sure how to be since this is all so new to me and
I'm
trying to make things harder by working at home! Hope you can get back
to me
with more info, because I do appricate it! I'm taking this class to
try to
learn, but I'm getting more confused!

"Roger Govier" wrote:

Hi Lauren

DataList from XL2003 has been replaced in XL2007 with
Insert tabTable

--
Regards
Roger Govier

"Lauren" wrote in message
...
I am in a class that is using the 2003 Excel book, but I'm using
2007, and
I'm having trouble finding the Table that used to be on the Data
menu. I
have to insert something in the column input cell. If anyone can
direct
me,
it is greatly appreciated!


--

Dave Peterson



All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com