Where are Data Forms for lists (tables) in Excel 2007?

R

Reed P. Wyatt

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
 
R

Roger Govier

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 button>Excel Options>Customise>All commands>scroll down to
Forms>Insert>OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top