FORM funtion 2003/2007 versions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in 2003 version there is the FORM funtion(under data heading) that speeds up
the population of small data bases by creating an "input" sheet.I am trying
to locate the same funtion in the 2007 version.
 
Sergio

It's not on the ribbon, you can only add it to the QAT (Quick Access
Toolbar) This is the small row of icons by default are top left, by the
Office Button.

To add this, right click on the QAT and select 'Customize Quick Access
Toolbar...'
Select 'Command Not in the Ribbon' from the 'Choose commands from' dropdown
In the listbox below select 'Form...' and click the 'Add' button

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

In addition you may see below link,

http://office.microsoft.com/en-us/excel/HA101491511033.aspx


to download workbook showing location of excel-2003 menu in excel-2007.
http://office.microsoft.com/search/redir.aspx?AssetID=AM101864291033&CTT=5&Origin=HA100860481033

In case you want to use excel-2003 menu in excel-2007, email me, you can
use my free addins excel-2003 menu for excel-2007. This will place worksheet
menu, standard toolbar & formatting toolbar in the addins tab.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
 
Back
Top