What use is the data form in excel. I've just started the excel expert
online course and it shows you how to create lists using data forms. But why
do you need a function like this when you can just type straight into excel?
Am I missing something here?

It just allows a reasonably friendly interface into the data, handling
next/previous, deleting and adding all in a familiar form style. Some users
like that sort of thing.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"carl" wrote in message
...
What use is the data form in excel. I've just started the excel expert
online course and it shows you how to create lists using data forms. But
why
do you need a function like this when you can just type straight into
excel?
Am I missing something here?

That would be fair enough if it entering data into cells wasn't already
userfriendly enough in Excel. This seems to be a case of adding a facility
for no apparent reason. It's actually easier to create a list without the
data form because you can copy and paste and drag down etc. outwith the data
form.

Agreed Carl, but some users are not that proficient, really! It does stop
them messing up.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"carl" wrote in message
...
That would be fair enough if it entering data into cells wasn't already
userfriendly enough in Excel. This seems to be a case of adding a
facility
for no apparent reason. It's actually easier to create a list without the
data form because you can copy and paste and drag down etc. outwith the
data
form.

Lol! Fair enough. But what's harder; typing information directly into cells
and then giving it a once over, or reading through manuals and doing online
excel courses in order to find out whether there is a function called 'data
form'? I've been using excel since it first came out and only recently found
out what it was for.

"Bob Phillips" wrote:

Agreed Carl, but some users are not that proficient, really! It does stop
them messing up.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"carl" wrote in message
...
That would be fair enough if it entering data into cells wasn't already
userfriendly enough in Excel. This seems to be a case of adding a
facility
for no apparent reason. It's actually easier to create a list without the
data form because you can copy and paste and drag down etc. outwith the
data
form.