Sunday, December 16, 2012

How to Create a Form Using Mircosoft 2007 Excel


1. Launch the Microsoft Excel 2007 program and open a blank spreadsheet. Click the 'Start' button and then 'Excel.' If you do not have Excel 2007, a free trial of Office may be downloaded from the Microsoft site (see Resources section). If a blank spreadsheet does not open automatically, click the 'Microsoft Office' button and then 'New.' Double-click the 'Blank Spreadsheet' icon to open a blank document.
2. Make certain the 'Developer' tab is available in the 'Ribbon.' Click the 'Microsoft Office' button and select 'Excel Options' to launch a separate dialogue window. Click the 'Show Developer tab' check box in the 'Top Options' section of the 'Popular' category. Click the 'OK' button.
3. Add form fields to the Excel 2007 spreadsheet. Go to the 'Developer' tab and locate the 'Controls' section. Click 'Insert' and select the desired form tool from under the 'Form Controls' section, such as 'List Box.' Click in an area of the spreadsheet that you want to add the form tool. The form tool will appear.
4. Adjust the form tool properties. Right-click the form tool and select the 'Format Control' option to launch the 'Properties' dialogue box. Depending on the type of form tool you selected, use the options in the 'Properties' window to change the details. Change the size of a form tool by clicking on it and using the small circles on the border to drag it to a desired size. To change the location of a form tool, click once on the border and drag it to a new area while holding down the mouse button.
5. Repeat steps 3 and 4 for each form tool you want to add to the spreadsheet. Save the form using the 'Save As' option under the 'Microsoft Office' button. Select a folder in which to save the Excel 2007 form using the arrows in the address bar of the 'Save As' dialogue box. Type a name for the form in the 'File name' field and click the 'Save' button to complete the process of creating a form using Microsoft 2007 Excel.

Blogger news