Excel 2013 For Dummies
Book image
Explore Book Buy On Amazon

Instead of entering the records of a data list directly in the table, you can use Excel 2013’s data form to make the entries. The only problem is that the command to display the form in a worksheet with a data list is not part of the Ribbon commands. You can access the data form only by adding its command button to the Quick Access toolbar or a custom Ribbon tab.

To add this command button to the Quick Analysis toolbar, follow these steps:

Click the Customize Quick Access Toolbar button at the end of the Quick Access toolbar and then click the More Commands item at the bottom of its drop-down menu.

Click the Customize Quick Access Toolbar button at the end of the Quick Access toolbar and then click the More Commands item at the bottom of its drop-down menu.

Excel opens the Excel Options dialog box with the Quick Access Toolbar tab selected.

The Form command button you want to add to the Quick Access toolbar is only available when you click the Commands Not in the Ribbon option on the Choose Commands From drop-down list.

Click the Commands Not in the Ribbon option near the top of the Choose Commands From drop-down list.

Click the Commands Not in the Ribbon option near the top of the Choose Commands From drop-down list.

This informs the program that it the command is not already in the Ribbon.

Click Form in the Choose Commands From list box and then click the Add button.

Click Form in the Choose Commands From list box and then click the Add button.

Excel adds the Form button to the very end of the Quick Access toolbar. If you so desire, you can click the Move Up and Move Down buttons to reposition the Form button on this toolbar.

Click OK to close the Excel Options dialog box and return to the worksheet with the data list.

Click OK to close the Excel Options dialog box and return to the worksheet with the data list.

Excel closes the Options dialog box and you can continue working on your worksheet.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is President of Mind Over Media, an online media company. He has written all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. Greg is an experienced educator with a wide variety of interests.

This article can be found in the category: