excel创建下拉列表多选
When you create a list in Excel, do you automatically convert that list to a formatted table?
在Excel中创建列表时,是否会自动将该列表转换为格式化表格 ?
If not, you’re missing out on one of Excel’s best features.
如果没有,您将错过Excel的最佳功能之一。
- Formatted tables are easy to set up, and make it easy to sort, filter, format, and expand your list. 格式化的表格易于设置,并且易于排序,过滤,格式化和扩展列表。
- You can refer to the table’s fields in your formulas, and the reference will adjust automatically, if you add or remove data. 您可以在公式中引用表格中的字段,如果您添加或删除数据,引用将自动调整。
设定资料 (Set Up Your Data)
There are a few things to check, before you turn your data list into a table. For example:
在将数据列表转换为表之前,需要检查一些事项。 例如:
- Add a heading in each data column 在每个数据列中添加标题
- Leave blank rows and columns around the list 在列表周围保留空白行和列
- Don’t leave blank rows or columns within the list 不要在列表中留空行或列
创建表 (Create the Table)
Once the data is set up, select any cell in the list, and click the Table command on the Ribbon’s Insert tab. When the Create Table window opens, check that the range is correct, and check the box for “My table has headers”.
设置数据后,在列表中选择任何单元格,然后在功能区的“插入”选项卡上单击“表格”命令。 当“创建表”窗口打开时,检查范围是否正确,然后选中“我的表有标题”框。
命名您的桌子 (Name Your Table)
After you create the table, change its name from the default “Table1” to something meaningful, such as “Orders”. This is especially important if you’re going to have more than one table in the workbook.
创建表后,将其名称从默认的“ Table1”更改为有意义的名称,例如“ Orders”。 如果您在工作簿中将有多个表,这尤其重要。
Just type over the old name in the Table Name box on the Ribbon’s Design tab.
只需在功能区的“设计”选项卡上的“表名”框中键入旧名称。
更多表格提示 (More Table Tips)
For more tips on working with tables, visit the Excel Tables page on my Contextures website.
有关使用表的更多提示,请访问我的Contextures网站上的Excel Tables页面。
观看视频 (Watch the Video)
If you haven’t made a formatted table before, watch this video, to see the steps.
如果您之前未制作过格式化表格,请观看此视频以查看步骤。
The video is also on the Excel Tables page on my Contextures website.
该视频也位于我的Contextures网站的Excel Tables页面上。
翻译自: https://contexturesblog.com/archives/2013/04/09/create-an-excel-table-from-a-list/
excel创建下拉列表多选