Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am accustomed to working with Excel 2000. I now own Excel 2007. I know
that "lists" in Excel 2000 equate to "tables" in 2007. However, when I look for the functions or buttons dealing with what was known as the "data form" in Excel 2000, I cannot locate them. Are there data forms for data entry in tables in Excel 2007? Are there analogs to data forms in 2007? Any help anyone could be would be greatly appreciated. Respectfully, Reed P. Wyatt -- Rpw |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Reed
The same keyboard shortcut will invoke forms in XL2007, as that used in XL200 Alt D O There is no icon on any of the Ribbons for Data Forms, but you can add one to the QAT (Quick Access Toolbar) Round Office buttonExcel OptionsCustomiseAll commandsscroll down to FormsInsertOK -- Regards Roger Govier "Reed P. Wyatt" wrote in message ... I am accustomed to working with Excel 2000. I now own Excel 2007. I know that "lists" in Excel 2000 equate to "tables" in 2007. However, when I look for the functions or buttons dealing with what was known as the "data form" in Excel 2000, I cannot locate them. Are there data forms for data entry in tables in Excel 2007? Are there analogs to data forms in 2007? Any help anyone could be would be greatly appreciated. Respectfully, Reed P. Wyatt -- Rpw |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Mr. Govier:
I thank you for your time and consideration. -- Rpw "Roger Govier" wrote: Hi Reed The same keyboard shortcut will invoke forms in XL2007, as that used in XL200 Alt D O There is no icon on any of the Ribbons for Data Forms, but you can add one to the QAT (Quick Access Toolbar) Round Office buttonExcel OptionsCustomiseAll commandsscroll down to FormsInsertOK -- Regards Roger Govier "Reed P. Wyatt" wrote in message ... I am accustomed to working with Excel 2000. I now own Excel 2007. I know that "lists" in Excel 2000 equate to "tables" in 2007. However, when I look for the functions or buttons dealing with what was known as the "data form" in Excel 2000, I cannot locate them. Are there data forms for data entry in tables in Excel 2007? Are there analogs to data forms in 2007? Any help anyone could be would be greatly appreciated. Respectfully, Reed P. Wyatt -- Rpw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forms Toolbar in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Forms | Excel Discussion (Misc queries) | |||
where on earth can I find data entry forms in Excel 2007 | Excel Discussion (Misc queries) | |||
Creating Forms with Excel 2007 | New Users to Excel | |||
Forms in Excel 2007 | Excel Worksheet Functions |