| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table DATA area drop down menu items disapper after switchof | Excel Discussion (Misc queries) | |||
| Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
| I can not select Pivot Table on my Data Menu | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
| Solver Table missing in Data Menu of Excel2003. Where is it? | Excel Worksheet Functions | |||
Linear Mode
