My Daily Microsoft
Notes from my daily work involving SharePoint, Excel and other Office applications.
Monday, August 16, 2010
Excel 2007: Locating Data Entry Form Button
If you used the data entry form in Excel 2003, you might recall that it was easily available from the Data menu.
In Excel 2007 you won’t find a button anywhere within the ribbon. You will have to add it manually for example to the Quick Access Toolbar.
To get the Form button visible, follow these steps:
Click on the down arrow on the Quick Access Toolbar
Locate and select Form from the command list on the left
Now you can find the Form button at the end of the QAT
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)