- excel数据分析:XI 关键性能指标,动作和名称集(一)
- excel vba教程:Excel插入图片的调整
- excel函数公式大全:Excel算年龄,这些公式会不会?
- 表格制作excel教程:VBA常用小代码:一键生成带超链接的工作表目录
Tables Part 2: Stickiness, Structured Selection, And More
列表(第二部分):附着,结构化选中…
(译者注:本文中的“附着”是原文中“Stickinees”或者“Stick”的直译)
One of the key benefits of tables is how other features in Excel 12 behave more predictably and more like you would expect when a table is present. This is made possible by the fact that Excel knows exactly where the table starts and ends, where the header row is, which cells make up the data and which columns they belong to, where the total row is, etc. So how exactly does this benefit the user? Here are some of the different ways in Excel’s awareness of the structure of your data changes the user experience.
Excel 12列表的一个核心优点在于-当使用列表时,其他相关功能能够更有预测性的迎合用户的需求,为了使这一切成为可能,Excel必须准确定知道列表的相关信息,如:开始和结束位置以及标题行位置,哪些单元格包含数据,它们分别属于哪些列等等。那么这些功能到底对终端用户有什么好处呢?Excel所具有的识别用户数据结构的不同方式可以带给用户不同以往的感受。
Stickiness
附着
When a user does something to a column of data in a table, it “sticks”. What exactly does that mean? If, for example, a user applies a conditional format to an entire column of a table, Excel assumes that the conditional format is always meant to cover the entire table column. So as new rows are added to the table, either in the middle or at the end, and as rows are deleted, Excel will automatically extend or contract the conditional formatting rule appropriately. The rule “sticks” to the column. We already saw this with the example in my previous post, but it doesn’t just stop with conditional formatting. This concept works with just about anything you can apply to a column, such as formatting (anything in the Format Cells dialog), cell protection, data validation, etc. In addition, this behaviour also applies to anything that holds on to a reference, such as formulas, charts and PivotTables.
当用户对列表的某列进行操作时,其相关的属性将被“附着”,这究竟是什么意思呢?例如用户在列表的某列使用了条件格式,Excel就会假定条件格式会永远应用到该列,所以无论是在列表的中间还是最后添加或者删除行时,Excel会相应地扩展或者收缩条件格式的范围及其相关的规则,如格式(单元格格式对话框中的所有选项)、单元格保护、数据有效性等,将“附着”在该列,另外,这种方式会应用在任何与引用相关的功能,例如公式、表格和数据透视表。
How do you make something “sticky”? There’s no explicit gesture for this. Excel just assumes that anytime something is done to an entire column, the setting is meant to always follow the column. So, if a user selects a table column and applies a data validation rule, that rule will grow and shrink with the table. Create a PivotTable that uses a table as its data source, and that Pivot Table will automatically pick up new rows from the table. Ditto for charts. To be precise, when I say “entire column” in this context, I really mean all the data rows. It is not necessary to also include the header cell – this way you don’t have to include the header in order to, for example, make the “currency” number format stick to a column for example.
那么,我们如何使某些功能“附着”哪?到目前为止我们没有任何方法可以定制它。Excel只是假设任何时候对于整列进行的设置,将永远跟随本列,如果用户选择列表的某列设置数据有效性,那么数据有效性的范围会随着列表而扩大或者收缩,如果设置列表为数据透视表的数据源,那么列表新增加的数据将自动添加到数据透视表中,图表具备同样的功能。准确的说,本文中所提及的“整列”是指包含列表中所有行的数据,但是标题行的数据不一定包含在内,
This stickiness also applies to new columns. For example, if a table is used as the data source for a chart, then any new columns I add to the table will get picked up by the chart. In addition, properties set on the entire table, headers, and the total row (more on what a total row is in a later post) are also “sticky”.
附着功能同样会应用到新增加的列,例如:一个列表作为图表的数据源,列表增加列时会自动更新图表,另外,整个表格的所有属性、标题和汇总(以后的帖子中会更多的阐述汇总)也会相应的“附着”。
Selection
选中
Now that Excel recognizes things like rows and columns in my tables, it is only natural that it provide simple ways to select those elements of a table. A single mouse click can select one or more rows, one or more columns, or the entire table. To select a column in a table, simply hover the mouse over the top of the header until the mouse cursor turns into a down-arrow and click.
现在Excel可以识别列表中的某些元素,如行和列,利用简单的方法选中这些元素就成为一个自然的需求,通过简单点击一次鼠标就可以选中一行或者多行、一列或者多列,乃至整个列表,如果希望选中列表的某列,只需要将鼠标移到标题行之上,当鼠标变成下箭头时点击鼠标就可以完成。
上一篇:excel宏教程:Excel设置正常显示负时间 下一篇:excel宏教程:Excel数值按目录形式排序
郑重声明:本文版权归原作者所有,转载文章仅为传播更多信息之目的,如作者信息标记有误,请第一时间联系我们修改或删除,多谢。