| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where on earth can I find data entry forms in Excel 2007 | Excel Discussion (Misc queries) | |||
| Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
| Can't seem to find way to have easy data entry AND analysis - idea | Excel Discussion (Misc queries) | |||
| Using Excel Grid as Office Map - Find Empty Desks? | Excel Discussion (Misc queries) | |||
| Find in a Grid | Excel Discussion (Misc queries) | |||
Hybrid Mode
