Tables Part 7: Good-looking, well-behaved table formatting made easy …
列表(第7部分)：精美实用的列表格式，唾手可得

If you’ve been reading the last few posts on tables, you may have noticed that the screenshots all had tables with formatting applied to the entire table. You may have thought I spent lots of time manually formatting the tables to look nice for this blog but in fact I hardly lifted a finger – I was using a brand new table feature in Excel 12 called “table styles” which made it possible to add formatting with one click. Table styles is a feature that provides a way to quickly format my entire table using a preset style definition. It is similar in concept to the AutoFormat feature Excel had in the past, with a couple key differences:
如果你已经读过上篇介绍列表的文章，你可能已注意到了应用于整个表格的所有列表格式的截图。也许你会认为，我为了使博客中的列表精美而花了大量的时间手工对列表进行格式化操作，实际上，我轻而易举地就获得了列表的精美效果——我使用了一种在Excel 12中被称作“列表样式”的新功能，运用它只需一次单击鼠标就可以添加格式。列表样式提供了一种应用预先设置的样式来快速格式整个表格的方法，与Excel原有的自动套用格式功能相似，主要的不同是：

• Table styles are dynamic, not a one-time formatting operation, so the formatting associated with the style behaves intelligently through many table actions – addition or deletion of rows or columns, sort, filter, etc.
• 列表样式是动态的，不只是以前的格式化操作。即格式与样式能在列表的操作中协同工作——添加或删除行或列，排序，筛选等等。
• There will be a healthy variety available. Excel 12 will ship with 30-40 table styles out of the box, and users will be able to vary the colours used by the style, so users will have a couple hundred styles available with one or two clicks of the mouse. If none of the built-in styles tickle your fancy or suit your presentation, you will be able to create your own custom styles which are sharable with others.
• 有大量各种各样可用的样式。Excel 12将发布30—40种列表样式(译者注：在后面的一篇文章中谈到了是50种)，并且用户能对(相同的)样式使用不同的颜色，因此，只需通过一次或两次单击就可得到上百种可用的样式。如果你不满意这些内置的样式或者它们不适合你的演示文档，你能创建自定义样式并与他人分享。
• The UI for applying styles – galleries in the ribbon – is a big step forward. This is a great example of the kinds of benefit the ribbon brings to Excel.
• 极大的改进了用于操作样式的用户界面——(列表样式)在ribbon(工具栏)的galleries(图形目录)中。这是ribbon(工具栏)能使Excel更易被操作的一个极好的例子。
• They are part of a broader set of work that includes cell styles, chart styles, PivotTable styles, and document themes. More on that in later posts, but the goal of all this work is to make it fast and easy to create professional-quality, consistent-looking documents.
• 列表样式和单元格样式、图表样式、数据透视表样式以及文档主题一样，提供一组更便于操作的功能。更多的内容将在以后的文章中介绍。总之，我们所做的一切都是为了使用户能快捷的创建具有专业水准和外观协调的文档。

Table styles are easy to apply – all you need to do is create a table, and a default table style is applied as soon as a table is created (don’t worry though, it doesn’t remove your existing formatting). If you don’t like the table style, you can pick something different or remove it altogether. The gallery of table styles is available directly from the table style ribbon. By default, we show you a single row of styles (the number depends on the resolution of your screen – more resolution, more space for styles).
应用列表样式是很容易的——你只需创建一个列表后应用缺省的列表样式即可(不必担心，这样的操作不会取消已有的格式)。如果你不喜欢(已应用的)列表样式，你可以选取其它的样式或者完全消除已应用的样式。可以直接从列表样式ribbon(工具栏中)的gallery(图形目录)中应用列表样式，在缺省的界面中显示了一行样式(显示的样式数量取决于你的屏幕分辨率——分辨率越大，列表样式显示得越多)。

If you want to see other styles, you can either scroll, or click on the drop-down to see all the styles available. (Note – the stuff you see in the screenshot are just place-holder styles that will be updated after further design work. I am very interested to hear any comments or feedback about what sort of formatting people use for their tables.)
如果你想看到其它的列表样式，你能使用滚动条或者单击下拉箭头来显示全部可用的列表样式。(注：下面的屏幕截图中所显示的不是最终所有的样式，我们将在做进一步的设计后对样式进行更新。我非常乐意听到您在列表中使用何种样式的意见或反馈。)

上一篇：excel表格教程：超级工具提示及折叠式 Ribbon 下一篇：excel函数教程：编辑Excel名称引用

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。