高頓網(wǎng)校友情提示，*7塔城會計繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-對編輯公式功能的改進Part 1_Excel 12 編輯欄等內(nèi)容公布如下：　　Meet the Excel 12 formula bar, or “don’t hijack my grid!”.
　　相約Excel 12 編輯欄——“請別妨礙到表格”
　　I’d like to shift gears a bit and talk about the work we’ve done to improve the experience around building and editing formulas.  For most customers, this is a core activity in their daily use of the product.  In planning for this version of Excel, we took a hard look at the features in this area, and we have made what we think are some significant improvements.  Over the next week, I am going to cover the work we have done in this area.
　　我想稍微調(diào)整進度，提前來談一下我們在創(chuàng)建和編輯公式方面所做的改進。對絕大多數(shù)用戶來說，創(chuàng)建和編輯公式是平時使用產(chǎn)品的主要工作。在規(guī)劃Excel 12時，我們仔細地研究過此方面的功能，并且做了看來較為充分的改善。接下來，我打算用一整周的時間，來討論我們對此所做的努力。
　　To start, let's take a look at some changes to the formula bar.  In Excel 12, we’ve redesigned the formula bar to be both flexible and less intrusive.  When we were researching the area of formula editing, the most common customer feedback we received about the formula bar was that it didn’t respect their data on the grid.  In order to display text in the active cell, the formula bar would spill into the sheet, often resulting in obscured column headers and sheet content. This could be frustrating when users were working with a spreadsheet containing cells with more than one line of text. We’ve addressed this issue in Excel 12 by giving formula bar its own space that never overlaps with the grid.  The * is similar to resizing a docked task pane.   Let’s take a look at an example.
　　先來看看編輯欄有了哪些變化？在Excel 12 里，為了讓您用得輕松自如，我們對編輯欄做了新設計。“編輯欄無視數(shù)據(jù)表的存在！”是調(diào)研中用戶給我們最多的反饋——顯示活動單元格的(長)文本時，編輯欄常會越位，擋到列標和工作表的內(nèi)容。用戶工作表單元格的文本超過一行時，這種令人沮喪的事就有可能會發(fā)生。在Excel 12中，這個問題已解決。編輯欄開始固守本位，不再占用表格的空間。解決方式有點類似調(diào)整任務欄的大小。我們來看個例子：
　　Below is an image of the Excel 2003 formula bar when a cell containing a lot of text is selected.  Column headers and data are obscured by the formula bar.
　　如下圖，在Excel 2003 中，選擇一個包含長文本的單元格時，編輯欄會遮擋到列標和數(shù)據(jù)。
　　Now let’s look at that same document in Excel 12.  Rather than spilling the content, we’ve added a scroll bar and kept the formula bar to a single line (which is the default state).
　　再來看看Excel 12中同一文檔的情況。為使編輯欄不越位，我們對其新增了滾動條，保證其僅顯示一行的文本內(nèi)容。（默認設置）
　　To display more cell content, users just need to adjust the height of the formula bar. This can be done in two ways - by dragging the resize bar at the bottom, or by clicking the auto expand/collapse button at the far right.  As users resize the formula bar, it pushes down the grid instead of overlapping it, so that spreadsheet content is never obscured. For the keyboard user, we’ve added a short cut that allows them to quickly toggle between the collapsed (1 line) and expanded state.
　　用戶僅需調(diào)整編輯欄的高度，就可用來顯示更多內(nèi)容。要實現(xiàn)它，有兩種方式——拖曳編輯欄底部的調(diào)整條，或點擊最右邊的自適應按鈕（譯者注：自動調(diào)整顯示一行或多行）。用戶調(diào)整編輯欄的高度時，表格也隨之下移，因此表里的內(nèi)容不會再被覆蓋到。我們還為鍵盤用戶添加了快捷鍵，以便在編輯欄的單行和多行模式間快速切換。
　　Another piece of feedback we heard from users about the formula bar was that the name box was not big enough to display long range names.  Accordingly, we’ve added the ability to resize the name box horizontally. This gives customers the ability to accommodate their long range names by dragging the name divider (circular dimple) left or right.
　　還有一個關于編輯欄的反饋信息。原有的名稱框太小，不夠用來顯示長名稱。為此，我們添加了水平方向調(diào)整名稱框的功能。用戶可以通過左右拖曳名稱框的分隔符（圓點），來調(diào)整寬度，使其能夠適應長名稱。
　　Here is an example of a long range name that doesn't fit in the name box:
　　這是名稱框中不夠位置顯示長名稱的例子：
　　Here is what things look like after the name box has been resized:
　　這是名稱框調(diào)寬之后的樣子：
　　Finally, I’ve already talked about limits, but I thought I’d mention a few here in the context of the formula bar.  The changes we’ve made will accommodate these increased limits and the larger formulas that result.
　　之前，我已經(jīng)談過Excel 12的限制問題。但在本文結(jié)束前，還有必要指出這些限制中與編輯欄相關的一些內(nèi)容。我們對編輯欄做了改變后，相應地加大了這些限制的上限，允許編輯更長的公式。
　　The maximum length of formulas (in characters)
　　Old Limit: 1k characters
　　New Limit: 8k characters
　　公式長度限制（字符）
　　舊限制：1K個字符
　　新限制：8k個字符
　　The number of levels of nesting that Excel allows in formulas
　　Old Limit: 7
　　New Limit: 64
　　公式嵌套的層數(shù)限制
　　舊限制： 7
　　新限制： 64
　　Maximum number of arguments to a function
　　Old Limit: 30
　　New Limit: 255
　　公式中參數(shù)的個數(shù)限制
　　舊限制： 30
　　新限制： 255
 　　　　
　　掃一掃微信，學習實務技巧
　　　
　　高頓網(wǎng)校特別提醒：已經(jīng)報名2014年財會考試的考生可按照復習計劃有效進行！另外，高頓網(wǎng)校2014年財會考試高清課程已經(jīng)開通，通過針對性地講解、訓練、答疑、模考，對學習過程進行全程跟蹤、分析、指導，可以幫助考生全面提升備考效果。