QQ登錄
微博登錄
微信登錄
Cell Styles - More Usable, better defaults
單元格樣式—更多可用的且已預設好的樣式
A few posts ago, I presented an overview of the work we are doing in the area of great looking documents. Over the next few posts, I want to walk through a number of the improvements we have made to styles. Today, let’s cover Cell Styles.
在前面的一些文章中，我概括地講述了我們在精美文檔方面所做的改進。在接下來的文章中，我想談談我們在樣式方面所做的一些改進。今天，讓我們先來談談單元格樣式。
“Cell Styles” were introduced in Excel v3. The basic idea, much like styles in Word (and other products), was to give users the ability to create and apply styles to cells, which accrued a few benefits. First, it gave users a way to create a consistent-looking document without needing to do nearly as much direct formatting. Second, it gave users the ability to quickly change the formatting of all cells that use a particular style … so, for example, if you wanted to change the number format for all your currency cells, you could do that with one quick change and not have to touch every cell. Styles can contain the following formatting: Font, Border, Number format, Alignment, Fills, and Protection.
“單元格樣式”最初在Excel v3版本中引入。像Word(和其它產品)中的樣式一樣，其基本的思想是提供對單元格創(chuàng)建和應用樣式的功能，這樣做有很多優(yōu)點：*9，創(chuàng)建風格一致的文檔而不需要去做大量重復的格式設置；第二，能運用一種特定的樣式快速改變所有單元格的格式……等。例如，如果你想改變所有已使用單元格的數字格式，只須應用一種特定的樣式而不必逐個地對單元格進行設置。樣式包括了下列格式：字體、邊框、數字格式、對齊、填充和保護。
In Excel 2007, we have made some updates to Cell Styles. What follows is a description of the changes.
在Excel 2007中，我們對單元格樣式作了一些更新。下面將描述所作的這些變化。
Excel 2007 uses the new ribbon UI to make this feature more discoverable and simpler to use. In current versions of Excel, users have to launch a modal dialog to apply Cell Styles, and there is no preview of what a style looks like before the user applies the style. In Excel 2007, we have put a gallery in the Excel ribbon. This has a number of benefits. First, styles are easier to apply – one or two clicks, no dialog involved. Second, styles are more discoverable. Third, users see exactly what the style will look like when applied. Here is what the gallery looks like in the ribbon (note that when we are done, the user will see 10 styles in the gallery by default, not 6).
Excel 2007使用了新的Ribbon(工具欄)用戶界面，這使得樣式更容易被找到并且操作更簡單。在現行的Excel版本中，用戶必須調出樣式對話框來應用單元格樣式，并且在應用某種樣式前沒有該樣式的預覽。而在Excel 2007中，我們在Excel Ribbon(工具欄)中設置了一個gallery(圖形目錄界面)，它的優(yōu)點是：*9，樣式直接通過單擊或雙擊就能應用，不需要對話框；第二，更容易找到合適的樣式；第三，應用某種樣式時，能預覽該樣式。下圖是樣式界面(注：我們完成該界面設計后，用戶可在界面中看到10個預設樣式，而不是6個)。
(Click to enlarge)
To apply a Cell Style to a cell, the user simply needs to select the cell(s) they want styled, and click on the appropriate style in the gallery. That’s it.
要應用單元格樣式，只需簡單地選取想要設置樣式的單元格，然后點擊界面中合適的樣式即可。
We are adding a lot more built-in Cell Styles. Currently the design has ~45, but we are still tweaking, so that number may go up or down. The built-in Cell Styles are designed around different tasks, with sets of styles for spreadsheet workflow, themed formatting of documents, titles and headers and number formats, etc. Here is a shot of what is in the product currently. (If you click on the drop-down arrow on the right-hand side of the gallery, the gallery expands to show its entire contents, which is what you see below … you can also scroll through the choices without expanding the gallery if you like.) I would love to hear any comments or feedback folks have on this set, be it the look of these styles, or the types of styles we have or haven’t included.
我們正在添加更多的內置單元格樣式，目前設計的有45種，但我們仍在改進，因此，樣式的數量可能增加也可能減少。這些內置的單元格樣式是圍繞不同的任務設計的，包括電子表格工作流程樣式，主題格式文檔，標題、頁首和數字格式樣式等等。這里有一張*7產品的截圖。(如果點擊gallery(圖形目錄)右邊的下拉箭頭，其將擴展顯示全部的內容，就像你在下圖中所看到的……如果你愿意的話，你也可以不擴展它而通過滾動來選擇。)我很樂意聆聽大家關于這個設置的任何意見或反饋，評價現有的樣式或者提出新的樣式。
(Click to enlarge)
Cell styles in Excel 2007 are now be tied to Document Themes (see previous posts here and here), allowing for cells using cell styles to be quickly re-themed and remain consistent with other themed elements such as charts, tables, shapes and PivotTables. Here is a what the built-in cell styles look like before and after a theme change. Note that only the themed styles and headings/titles change (by design), and that the font and colour change as part of the theme change.
在Excel 2007中，單元格樣式依存于Document Themes(文檔主題)(見前面的文章，請點擊這里和這里)<譯者注：可使用document>，允許使用單元格樣式為單元格快速的重設主題，且保持和其它已設置主題的對象如圖表、表格、形狀和數據透視表一致。下圖是內置的單元格樣式在主題變化前后的樣子。僅僅只是主題化的樣式和題目/標題變化，且字體和顏色作為主題的一部分也發(fā)生了變化。<譯者注：可使用document><譯者注：可使用document><譯者注：可使用document><譯者注：可使用document><譯者注：可使用document><譯者注：可使用document><譯者注：可使用document>
(Click to enlarge)
Of course, these cell styles are completely customizable. You can modify or delete the existing styles and add your own for your needs, using either context menus or controls in the gallery.
當然，完全可以自定義單元格樣式。使用gallery(圖形目錄)中的按鈕或者 Context menus(智能菜單)，你能夠修改或刪除已有的樣式，以及添加自已的樣式。
That’s it for this time – next time, a bit more on Table Styles.
上面就是本次所介紹的內容，下次將詳細介紹表格樣式。
掃一掃微信，學習實務技巧
