excel数据表单_在弹出表单中编辑Excel 2010列表数据

excel数据表单

If you're working with a list of data in Excel, you can use the built-in Data Form to view and edit the data.

如果您正在使用Excel中的数据列表，则可以使用内置的数据表单来查看和编辑数据。

Displaying up to 32 fields, it lets you view and edit one record at a time. You can also find and edit records, or add and delete them.

它最多显示32个字段，使您可以一次查看和编辑一条记录。 您还可以查找和编辑记录，或添加和删除记录。

In Excel 2003 and earlier versions, Form was on the Data menu. Select a cell in the list, then click the Form command, and start editing. It was a quick and easy way to work with a list.

在Excel 2003和更早版本中，“窗体”位于“数据”菜单上。 在列表中选择一个单元格，然后单击“表单”命令，然后开始编辑。 这是处理列表的快速简便的方法。

将表单添加到Excel 2010快速访问工具栏 (Add Form to Excel 2010 Quick Access Toolbar)

Unfortunately, the handy Data Form feature wasn't included in the Excel 2010 Ribbon – or if it's there, I can't find it!

不幸的是，便捷的数据表单功能未包含在Excel 2010功能区中–否则，如果找不到该功能！

So, if you want to use the Data Form, you can add it to the Ribbon or to the Quick Access Toolbar (QAT).

因此，如果要使用数据表单，可以将其添加到功能区或快速访问工具栏(QAT)。

1. Right-click the QAT, and click Customize Quick Access Toolbar
   右键单击“ QAT”，然后单击“自定义快速访问工具栏”
2. From the drop down list, select All Commands
   从下拉列表中，选择所有命令
3. Scroll down and click on Form..., then click Add, to put it on the QAT
   向下滚动并单击Form ...，然后单击Add，将其放入QAT
4. Click OK, to close the window
   单击确定，关闭窗口
5. Select a cell in the list, then click the Form button on the QAT
   在列表中选择一个单元格，然后单击QAT上的“表单”按钮

It's too bad that this feature was never updated, to include more than 32 fields, but it's great for tables with fewer columns than that.

遗憾的是，此功能从未更新过，无法包含32个以上的字段，但对于列数少于该字段的表来说，这非常好。

观看数据表视频 (Watch the Data Form Video)

To see the steps for using the Data Form, and adding it to the Quick Access Toolbar, you can watch this short video tutorial.

要查看使用数据表单并将其添加到快速访问工具栏的步骤，您可以观看此简短的视频教程。

演示地址

翻译自: https://contexturesblog.com/archives/2012/08/21/edit-excel-2010-list-data-in-popup-form/

excel数据表单