Attribute_Brands is a named range that should contain your list items. Use the drop down to the left of the formula bar to jump to the named range, then edit it. If you add or remove items you will need to adjust the range the named range covers.
The answers above will work for changing the values.
If you want to change the number of cells in your list (e.g. I have a list called 'revisions' which has 4 items, I now need 7 items) you will find that you can't simply select your list and amend it on the sheet, So:
go to your 'Formulas' tab
choose "Name Manager"
a pop up box will show what is available for editing. Your list should be in it. Select your list and edit the range.
发布评论
评论（3）
Attribute_Brands 是一个命名范围。
在任何工作表（选项卡）上按 F5 并在参考框中输入 Attribute_Brands，然后单击“确定”按钮。
这将带您到指定的范围。
可以通过在单元格中键入新值来更新其中的数据。
命名范围可以通过“插入 - 名称 - 定义”菜单进行更改。
Attribute_Brands is a named range.
On any worksheet (tab) press F5 and type Attribute_Brands into the reference box and click on the OK button.
This will take you to the named range.
The data in it can be updated by typing new values into the cells.
The named range can be altered via the 'Insert - Name - Define' menu.
Attribute_Brands 是一个命名范围，应包含您的列表项。使用编辑栏左侧的下拉菜单跳转到命名范围，然后对其进行编辑。如果添加或删除项目，您将需要调整命名范围涵盖的范围。
Attribute_Brands is a named range that should contain your list items. Use the drop down to the left of the formula bar to jump to the named range, then edit it. If you add or remove items you will need to adjust the range the named range covers.
上面的答案将适用于更改值。
如果您想更改列表中的单元格数量（例如，我有一个名为“修订”的列表，其中有 4 个项目，我现在需要 7 个项目），您会发现您不能简单地选择您的列表并在工作表上修改它，因此：
转到“公式”选项卡，
选择“名称管理器”，
弹出框将显示可编辑的内容。你的清单应该在里面。选择您的列表并编辑范围。
The answers above will work for changing the values.
If you want to change the number of cells in your list (e.g. I have a list called 'revisions' which has 4 items, I now need 7 items) you will find that you can't simply select your list and amend it on the sheet, So:
go to your 'Formulas' tab
choose "Name Manager"
a pop up box will show what is available for editing. Your list should be in it. Select your list and edit the range.