|
where can i find grid data entry in excel?
i cannot find how to enter data in grid form as opposed to row by row . This
is usefull for co ntacts etc. |
where can i find grid data entry in excel?
JMH
How about DataForm...? Set up your headers across the top row first and then invoke it -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS 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" wrote in message ... i cannot find how to enter data in grid form as opposed to row by row . This is usefull for co ntacts etc. |
where can i find grid data entry in excel?
Nick Thank you, but i cannot 'Form' in the Data ribbon...is there anything i
should do to make it visible? JM "Nick Hodge" wrote: JMH How about DataForm...? Set up your headers across the top row first and then invoke it -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS 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" wrote in message ... i cannot find how to enter data in grid form as opposed to row by row . This is usefull for co ntacts etc. |
where can i find grid data entry in excel?
Sorry
There was no reference to Excel 2007, to do this you need to add the command to the QAT Office buttonExcel optionsCustomizeSelect 'commands not in ribbon' and add 'Forms...' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS 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" wrote in message ... Nick Thank you, but i cannot 'Form' in the Data ribbon...is there anything i should do to make it visible? JM "Nick Hodge" wrote: JMH How about DataForm...? Set up your headers across the top row first and then invoke it -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS 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" wrote in message ... i cannot find how to enter data in grid form as opposed to row by row . This is usefull for co ntacts etc. |
| All times are GMT +1. The time now is 07:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com