Friday, March 22, 2013

How to Make an Excel Sheet Into a Form


1. Open Excel 2010 and select a workbook containing data. Click the 'File' tab and select 'Open.' Browse the files and locate the workbook. Click the workbook and select the 'Open' button. The workbook will open.
2. Add the form to the Quick Access Toolbar by clicking the right drop-down arrow on the Quick Access Toolbar. Select 'More Commands.' Click 'All Commands' in the 'Choose Commands From' section. Drag the scroll bar down and click 'Form.' Click the 'Add' button to add the button to the Quick Access Toolbar. Click 'OK.'
3. Highlight the data in your spreadsheet. Make sure you highlight the column headers too. Click the 'Form' button. A form will appear containing your data.

Blogger news