高頓網(wǎng)校友情提示，*7塔城會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-對(duì)編輯公式功能的改進(jìn)Part 1_Excel 12 編輯欄等內(nèi)容公布如下：　　Meet the Excel 12 formula bar, or “don’t hijack my grid!”.
　　相約Excel 12 編輯欄——“請(qǐng)別妨礙到表格”
　　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)整進(jìn)度，提前來(lái)談一下我們?cè)趧?chuàng)建和編輯公式方面所做的改進(jìn)。對(duì)絕大多數(shù)用戶來(lái)說(shuō)，創(chuàng)建和編輯公式是平時(shí)使用產(chǎn)品的主要工作。在規(guī)劃Excel 12時(shí)，我們仔細(xì)地研究過(guò)此方面的功能，并且做了看來(lái)較為充分的改善。接下來(lái)，我打算用一整周的時(shí)間，來(lái)討論我們對(duì)此所做的努力。
　　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.
　　先來(lái)看看編輯欄有了哪些變化？在Excel 12 里，為了讓您用得輕松自如，我們對(duì)編輯欄做了新設(shè)計(jì)。“編輯欄無(wú)視數(shù)據(jù)表的存在！”是調(diào)研中用戶給我們最多的反饋——顯示活動(dòng)單元格的(長(zhǎng))文本時(shí)，編輯欄常會(huì)越位，擋到列標(biāo)和工作表的內(nèi)容。用戶工作表單元格的文本超過(guò)一行時(shí)，這種令人沮喪的事就有可能會(huì)發(fā)生。在Excel 12中，這個(gè)問(wèn)題已解決。編輯欄開(kāi)始固守本位，不再占用表格的空間。解決方式有點(diǎn)類似調(diào)整任務(wù)欄的大小。我們來(lái)看個(gè)例子：
　　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 中，選擇一個(gè)包含長(zhǎng)文本的單元格時(shí)，編輯欄會(huì)遮擋到列標(biāo)和數(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).
　　再來(lái)看看Excel 12中同一文檔的情況。為使編輯欄不越位，我們對(duì)其新增了滾動(dòng)條，保證其僅顯示一行的文本內(nèi)容。（默認(rèn)設(shè)置）
　　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)整編輯欄的高度，就可用來(lái)顯示更多內(nèi)容。要實(shí)現(xiàn)它，有兩種方式——拖曳編輯欄底部的調(diào)整條，或點(diǎn)擊最右邊的自適應(yīng)按鈕（譯者注：自動(dòng)調(diào)整顯示一行或多行）。用戶調(diào)整編輯欄的高度時(shí)，表格也隨之下移，因此表里的內(nèi)容不會(huì)再被覆蓋到。我們還為鍵盤(pán)用戶添加了快捷鍵，以便在編輯欄的單行和多行模式間快速切換。
　　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.
　　還有一個(gè)關(guān)于編輯欄的反饋信息。原有的名稱框太小，不夠用來(lái)顯示長(zhǎng)名稱。為此，我們添加了水平方向調(diào)整名稱框的功能。用戶可以通過(guò)左右拖曳名稱框的分隔符（圓點(diǎn)），來(lái)調(diào)整寬度，使其能夠適應(yīng)長(zhǎng)名稱。
　　Here is an example of a long range name that doesn't fit in the name box:
　　這是名稱框中不夠位置顯示長(zhǎng)名稱的例子：
　　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)談過(guò)Excel 12的限制問(wèn)題。但在本文結(jié)束前，還有必要指出這些限制中與編輯欄相關(guān)的一些內(nèi)容。我們對(duì)編輯欄做了改變后，相應(yīng)地加大了這些限制的上限，允許編輯更長(zhǎng)的公式。
　　The maximum length of formulas (in characters)
　　Old Limit: 1k characters
　　New Limit: 8k characters
　　公式長(zhǎng)度限制（字符）
　　舊限制：1K個(gè)字符
　　新限制：8k個(gè)字符
　　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ù)的個(gè)數(shù)限制
　　舊限制： 30
　　新限制： 255
 　　　　
　　掃一掃微信，學(xué)習(xí)實(shí)務(wù)技巧
　　　
　　高頓網(wǎng)校特別提醒：已經(jīng)報(bào)名2014年財(cái)會(huì)考試的考生可按照復(fù)習(xí)計(jì)劃有效進(jìn)行！另外，高頓網(wǎng)校2014年財(cái)會(huì)考試高清課程已經(jīng)開(kāi)通，通過(guò)針對(duì)性地講解、訓(xùn)練、答疑、?？?，對(duì)學(xué)習(xí)過(guò)程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。