where can i find grid data entry in excel?

[JMH]

i cannot find how to enter data in grid form as opposed to row by row . This
is usefull for co ntacts etc.

 

[Nick Hodge]

JMH

How about

Data>Form...?

Set up your headers across the top row first and then invoke it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

 

[JMH]

Nick Thank you, but i cannot 'Form' in the Data ribbon...is there anything i
should do to make it visible?
JM

 

[Nick Hodge]

Sorry

There was no reference to Excel 2007, to do this you need to add the command
to the QAT

Office button>Excel options>Customize>Select 'commands not in ribbon' and
add 'Forms...'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk