エクセルでデータフォームからのデータ入力

Hi 裕 菅原,

Good Day. I'm Jhun an independent advisor. Below are the steps to enter data using a data form in Excel.

A. Prepare your data as a table.

1. Open Excel and go to the worksheet where you want to enter data.
2. Make sure your column headers are in row 1.
3. Select all your headers (you may include some empty rows below if you like).
4. Go to Insert > Table or press Ctrl + T.
5. Make sure “My table has headers” is checked, click OK. The data form only works if your data is in a table format with headers.

B. Add Data form button. As a default, the Data Form is not visible in the ribbon. You need to add it to Quick Access Toolbar:

1. Click the down arrow at the top left (Quick Access Toolbar) → More Commands.
2. In Choose commands from, select Commands Not in the Ribbon.
3. Scroll down and find Form.
4. Click Add > OK.
5. Now a Form button will appear in the Quick Access Toolbar.

C. Use Data Form to enter a data.

1. Click anywhere in your table.
2. In Quick Access Toolbar, click the Form button.
3. A dialog box will appear with your column headers as fields.
4. Enter data into the fields.
5. Click "New" to add the row to your table.
6. Repeat for each new row.
7. You can also Find, Delete, or Scroll through existing records.

I hope this helps.

Regards,
Jhun