Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Where are Data Forms for lists (tables) in Excel 2007?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Where are Data Forms for lists (tables) in Excel 2007?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Where are Data Forms for lists (tables) in Excel 2007?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forms Toolbar in Excel 2007 Gary Excel Discussion (Misc queries) 2 September 27th 12 08:04 PM
Excel 2007 Forms Brad Wylie Excel Discussion (Misc queries) 2 March 1st 07 03:28 PM
where on earth can I find data entry forms in Excel 2007 retep Excel Discussion (Misc queries) 4 February 10th 07 03:14 PM
Creating Forms with Excel 2007 Mishu New Users to Excel 2 January 2nd 07 11:20 PM
Forms in Excel 2007 Ben Enfield Excel Worksheet Functions 2 June 2nd 06 11:11 AM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"