G Guest Apr 22, 2007 #1 i cannot find how to enter data in grid form as opposed to row by row . This is usefull for co ntacts etc.
i cannot find how to enter data in grid form as opposed to row by row . This is usefull for co ntacts etc.
N Nick Hodge Apr 22, 2007 #2 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 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
G Guest Apr 22, 2007 #3 Nick Thank you, but i cannot 'Form' in the Data ribbon...is there anything i should do to make it visible? JM
Nick Thank you, but i cannot 'Form' in the Data ribbon...is there anything i should do to make it visible? JM
N Nick Hodge Apr 22, 2007 #4 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
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
