 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2007where 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. JMH How about Data>Form...? Set up your headers across the top row first and then invoke it  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS 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 >i cannot find how to enter data in grid form as opposed to row by row . >This > is usefull for co ntacts etc. Nick Thank you, but i cannot 'Form' in the Data ribbon...is there anything i should do to make it visible? JM > JMH > [quoted text clipped - 7 lines] > >This > > is usefull for co ntacts etc. 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...' SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS 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 > Nick Thank you, but i cannot 'Form' in the Data ribbon...is there anything > i [quoted text clipped - 12 lines] >> >This >> > is usefull for co ntacts etc. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.