Saturday, November 23, 2013

How to Use a Data Form in Microsoft Excel 2007


1. Open the Microsoft Excel 2007 program on your computer and then click on any cell where you want the form to start.
2. Click on the arrow next to the Quick Access toolbar and then click on the 'More Commands' option. Select 'All Commands' and then click on the 'Form' button from the list.
3. Click on the 'Add' button and then 'OK.' Click 'Form' from the Quick Access toolbar, and then you can enter your data into the first row of the form.
4. Click on the 'New' button to add a new row and then enter your data. Press the 'Enter' key on your keyboard, and the row of data will be added to the bottom of the form.
5. Select any row that you want to remove and then click on the 'Delete' button. Choose 'Close' at any time to close out of the data form and return to your worksheet.

Blogger news