克拉瑪依會計繼續(xù)教育網(wǎng)：Excel2007新知-單元格樣式

　　“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(和其它產(chǎn)品)中的樣式一樣，其基本的思想是提供對單元格創(chuàng)建和應(yīng)用樣式的功能，這樣做有很多優(yōu)點：*9，創(chuàng)建風(fēng)格一致的文檔而不需要去做大量重復(fù)的格式設(shè)置；第二，能運用一種特定的樣式快速改變所有單元格的格式……等。例如，如果你想改變所有已使用單元格的數(shù)字格式，只須應(yīng)用一種特定的樣式而不必逐個地對單元格進(jìn)行設(shè)置。樣式包括了下列格式：字體、邊框、數(shù)字格式、對齊、填充和保護(hù)。

　　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(工具欄)用戶界面，這使得樣式更容易被找到并且操作更簡單。在現(xiàn)行的Excel版本中，用戶必須調(diào)出樣式對話框來應(yīng)用單元格樣式，并且在應(yīng)用某種樣式前沒有該樣式的預(yù)覽。而在Excel 2007中，我們在Excel Ribbon(工具欄)中設(shè)置了一個gallery(圖形目錄界面)，它的優(yōu)點是：*9，樣式直接通過單擊或雙擊就能應(yīng)用，不需要對話框；第二，更容易找到合適的樣式；第三，應(yīng)用某種樣式時，能預(yù)覽該樣式。下圖是樣式界面(注：我們完成該界面設(shè)計后，用戶可在界面中看到10個預(yù)設(shè)樣式，而不是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.

　　要應(yīng)用單元格樣式，只需簡單地選取想要設(shè)置樣式的單元格，然后點擊界面中合適的樣式即可。

　　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.

　　我們正在添加更多的內(nèi)置單元格樣式，目前設(shè)計的有45種，但我們?nèi)栽诟倪M(jìn)，因此，樣式的數(shù)量可能增加也可能減少。這些內(nèi)置的單元格樣式是圍繞不同的任務(wù)設(shè)計的，包括電子表格工作流程樣式，主題格式文檔，標(biāo)題、頁首和數(shù)字格式樣式等等。這里有一張*7產(chǎn)品的截圖。(如果點擊gallery(圖形目錄)右邊的下拉箭頭，其將擴(kuò)展顯示全部的內(nèi)容，就像你在下圖中所看到的……如果你愿意的話，你也可以不擴(kuò)展它而通過滾動來選擇。)我很樂意聆聽大家關(guān)于這個設(shè)置的任何意見或反饋，評價現(xiàn)有的樣式或者提出新的樣式。

　　(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>，允許使用單元格樣式為單元格快速的重設(shè)主題，且保持和其它已設(shè)置主題的對象如圖表、表格、形狀和數(shù)據(jù)透視表一致。下圖是內(nèi)置的單元格樣式在主題變化前后的樣子。僅僅只是主題化的樣式和題目/標(biāo)題變化，且字體和顏色作為主題的一部分也發(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.

　　當(dāng)然，完全可以自定義單元格樣式。使用gallery(圖形目錄)中的按鈕或者 Context menus(智能菜單)，你能夠修改或刪除已有的樣式，以及添加自已的樣式。

　　That’s it for this time – next time, a bit more on Table Styles.

　　上面就是本次所介紹的內(nèi)容，下次將詳細(xì)介紹表格樣式。

 　　　　

　　掃一掃微信，學(xué)習(xí)實務(wù)技巧

　　高頓網(wǎng)校特別提醒：已經(jīng)報名2014年財會考試的考生可按照復(fù)習(xí)計劃有效進(jìn)行！另外，高頓網(wǎng)校2014年財會考試高清課程已經(jīng)開通，通過針對性地講解、訓(xùn)練、答疑、?？?，對學(xué)習(xí)過程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。