單元格樣式

單元格樣式

譯者：fanjy?? 來源：http://blogs.msdn.com/excel 發表于：2006年7月7日

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

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(圖形目錄界面)，它的優點是：第一，樣式直接通過單擊或雙擊就能應用，不需要對話框；第二，更容易找到合適的樣式；第三，應用某種樣式時，能預覽該樣式。下圖是樣式界面(注：我們完成該界面設計后，用戶可在界面中看到10個預設樣式，而不是6個)。

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. 上面就是本次所介紹的內容，下次將詳細介紹表格樣式。

Published Wednesday, March 29, 2006 11:36 PM by David Gainer

非常感謝Kevin的幫助和指導!

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。