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

1 comment:

  1. You are my inspiration I possess few web logs and sometimes run out from to post . spreadsheet expert

    ReplyDelete