PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?UmVlZCBQLiBXeWF0dA==?=
Guest
Posts: n/a
 
      2nd Jul 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
 
Reply With Quote
 
 
 
 
Roger Govier
Guest
Posts: n/a
 
      2nd Jul 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 button>Excel Options>Customise>All commands>scroll down to
Forms>Insert>OK

--
Regards

Roger Govier


"Reed P. Wyatt" <(E-Mail Removed)> wrote in message
news:2B23576E-D6A0-4E2B-A5B4-(E-Mail Removed)...
>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 With Quote
 
=?Utf-8?B?UmVlZCBQLiBXeWF0dA==?=
Guest
Posts: n/a
 
      2nd Jul 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 button>Excel Options>Customise>All commands>scroll down to
> Forms>Insert>OK
>
> --
> Regards
>
> Roger Govier
>
>
> "Reed P. Wyatt" <(E-Mail Removed)> wrote in message
> news:2B23576E-D6A0-4E2B-A5B4-(E-Mail Removed)...
> >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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Working with Lists (Now Tables) in Excel 2007 Christie P Microsoft Excel Misc 2 15th Jul 2009 04:41 PM
Convert Excel 2007 data forms to Access 2007 ? Cris22149 Microsoft Excel Misc 0 19th Nov 2008 02:13 AM
Excel 2007 - Subtotals Below the Data in Pivot Tables TB in DC Microsoft Excel Misc 2 3rd Nov 2008 02:19 AM
Excel 2007 data forms loghome4sale@gmail.com Microsoft Excel Misc 1 8th Aug 2007 03:29 AM
Excel 2007 - Tables now (lists in 2003) =?Utf-8?B?Q2hyaXNL?= Microsoft Excel Misc 1 25th Jul 2007 12:26 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:30 AM.