How to make an excel sheet into a form

Written by emmanuelle douglas
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to make an excel sheet into a form
(Photos.com/Photos.com/Getty Images)

You can turn your Excel spreadsheet data into a form when you need to perform repetitive data entry. The form makes this process easier and Excel has a button interface to assist with the data entry. The form button is not on the ribbon by default. It must be added to the Quick Access Toolbar. Once it is added, any spreadsheet that contains column headers and data can be transformed into a form. Use the Excel form for quick data entry in your spreadsheets.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 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. 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. 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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.