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:
  1. Click on the down arrow on the Quick Access Toolbar
  2. Select More Commands
  3. Select All Commands
  4. Locate and select Form from the command list on the left
  5. Click Add
  6. Click OK
  7. Now you can find the Form button at the end of the QAT

No comments:

Post a Comment