吐魯番會計繼續(xù)教育網(wǎng)：Excel2007新知-Tables Part 2_附著，結(jié)構(gòu)化選中

高頓網(wǎng)校友情提示，*7吐魯番會計繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-Tables Part 2_附著，結(jié)構(gòu)化選中等內(nèi)容公布如下：　　Tables Part 2: Stickiness, Structured Selection, And More

　?。ㄗg者注：本文中的“附著”是原文中“Stickinees”或者“Stick”的直譯）

　　One of the key benefits of tables is how other features in Excel 12 behave more predictably and more like you would expect when a table is present. This is made possible by the fact that Excel knows exactly where the table starts and ends, where the header row is, which cells make up the data and which columns they belong to, where the total row is, etc. So how exactly does this benefit the user? Here are some of the different ways in Excel’s awareness of the structure of your data changes the user experience.

　　Excel 12列表的一個核心優(yōu)點在于－當(dāng)使用列表時，其他相關(guān)功能能夠更有預(yù)測性的迎合用戶的需求，為了使這一切成為可能，Excel必須準(zhǔn)確定知道列表的相關(guān)信息，如：開始和結(jié)束位置以及標(biāo)題行位置，哪些單元格包含數(shù)據(jù)，它們分別屬于哪些列等等。那么這些功能到底對終端用戶有什么好處呢？Excel所具有的識別用戶數(shù)據(jù)結(jié)構(gòu)的不同方式可以帶給用戶不同以往的感受。

　　When a user does something to a column of data in a table, it "sticks". What exactly does that mean? If, for example, a user applies a conditional format to an entire column of a table, Excel assumes that the conditional format is always meant to cover the entire table column. So as new rows are added to the table, either in the middle or at the end, and as rows are deleted, Excel will automatically extend or contract the conditional formatting rule appropriately. The rule “sticks” to the column. We already saw this with the example in my previous post, but it doesn’t just stop with conditional formatting. This concept works with just about anything you can apply to a column, such as formatting (anything in the Format Cells dialog), cell protection, data validation, etc. In addition, this * also applies to anything that holds on to a reference, such as formulas, charts and PivotTables.

　　當(dāng)用戶對列表的某列進(jìn)行操作時，其相關(guān)的屬性將被“附著”，這究竟是什么意思呢？例如用戶在列表的某列使用了條件格式，Excel就會假定條件格式會永遠(yuǎn)應(yīng)用到該列，所以無論是在列表的中間還是最后添加或者刪除行時，Excel會相應(yīng)地擴展或者收縮條件格式的范圍及其相關(guān)的規(guī)則，如格式（單元格格式對話框中的所有選項）、單元格保護、數(shù)據(jù)有效性等，將“附著”在該列，另外，這種方式會應(yīng)用在任何與引用相關(guān)的功能，例如公式、表格和數(shù)據(jù)透視表。

　　How do you make something “sticky”? There’s no explicit gesture for this. Excel just assumes that anytime something is done to an entire column, the setting is meant to always follow the column. So, if a user selects a table column and applies a data validation rule, that rule will grow and shrink with the table. Create a PivotTable that uses a table as its data source, and that Pivot Table will automatically pick up new rows from the table. Ditto for charts. To be precise, when I say “entire column” in this context, I really mean all the data rows. It is not necessary to also include the header cell - this way you don’t have to include the header in order to, for example, make the “currency” number format stick to a column for example.

　　那么，我們?nèi)绾问鼓承┕δ?ldquo;附著”哪？到目前為止我們沒有任何方法可以定制它。Excel只是假設(shè)任何時候?qū)τ谡羞M(jìn)行的設(shè)置，將永遠(yuǎn)跟隨本列，如果用戶選擇列表的某列設(shè)置數(shù)據(jù)有效性，那么數(shù)據(jù)有效性的范圍會隨著列表而擴大或者收縮，如果設(shè)置列表為數(shù)據(jù)透視表的數(shù)據(jù)源，那么列表新增加的數(shù)據(jù)將自動添加到數(shù)據(jù)透視表中，圖表具備同樣的功能。準(zhǔn)確的說，本文中所提及的“整列”是指包含列表中所有行的數(shù)據(jù)，但是標(biāo)題行的數(shù)據(jù)不一定包含在內(nèi)，

　　This stickiness also applies to new columns. For example, if a table is used as the data source for a chart, then any new columns I add to the table will get picked up by the chart. In addition, properties set on the entire table, headers, and the total row (more on what a total row is in a later post) are also "sticky".

　　附著功能同樣會應(yīng)用到新增加的列，例如：一個列表作為圖表的數(shù)據(jù)源，列表增加列時會自動更新圖表，另外，整個表格的所有屬性、標(biāo)題和匯總（以后的帖子中會更多的闡述匯總）也會相應(yīng)的“附著”。

　　Now that Excel recognizes things like rows and columns in my tables, it is only natural that it provide simple ways to select those elements of a table. A single mouse click can select one or more rows, one or more columns, or the entire table. To select a column in a table, simply hover the mouse over the top of the header until the mouse cursor turns into a down-arrow and click.

　　現(xiàn)在Excel可以識別列表中的某些元素，如行和列，利用簡單的方法選中這些元素就成為一個自然的需求，通過簡單點擊一次鼠標(biāo)就可以選中一行或者多行、一列或者多列，乃至整個列表，如果希望選中列表的某列，只需要將鼠標(biāo)移到標(biāo)題行之上，當(dāng)鼠標(biāo)變成下箭頭時點擊鼠標(biāo)就可以完成。

　　To select a row, hover the mouse over to the left edge of a row until the mouse cursor turns into a right-arrow and click. And to select the entire table, hover the mouse over the top-left corner of the table until you see an arrow that points down and right and click.

　　如果希望選中列表的某行，只需要將鼠標(biāo)移到列表左側(cè)邊界，當(dāng)鼠標(biāo)變成右箭頭時點擊鼠標(biāo)就可以完成，如果希望選中整個列表，則需要將鼠標(biāo)移列表的左上角，當(dāng)鼠標(biāo)變成向右下方的箭頭時點擊鼠標(biāo)就可以完成。

　　Note that column and table selection have two *s. The first click always selects just the data portion of the column/table. This makes it easy to select a column of numbers and apply formatting or other properties to the data in the column. The second click expands the selection to cover everything in the column/table, header and all. This is useful for copy/paste operations or rearranging columns in a table.

　　注意選中行和列有兩種方式，*9次點擊總是僅僅選中列表中某列的數(shù)據(jù)部分，這樣可以很容易的選中一列數(shù)字，并設(shè)置格式或者修改其他屬性，第二次點擊將選中列表中該列的所有內(nèi)容，包括標(biāo)題行在內(nèi)，這種方式可以用于復(fù)制/粘貼或者調(diào)整該列在列表中的位置。

　　If you are a keyboard junkie (like many of the people reading this seem to be), note that there is keyboard support for these selection *s. The existing shortcut keys for row and column selection, SHIFT+SPACE and CTRL+SPACE respectively, have been modified to work with tables. For example, pressing CTRL+SPACE once selects all the data rows in a table column. The second press expands the selection to encompass the entire table column, and the third press expands it again to encompass the entire worksheet column.

　　如果你喜歡使用快捷鍵（似乎閱讀這個帖子的多少人都是這樣），使用鍵盤同樣可以實現(xiàn)選中功能，在先前版本中使用的行和列的選擇快捷鍵和現(xiàn)在可以仍然可以應(yīng)用于列表，例如：按一次可以選中列表中某列的所有數(shù)據(jù)，第二次按下快捷鍵可以列表中該列第所有內(nèi)容，再次按下快捷鍵則選中工作表的整列。

 　　　　

　　掃一掃微信，學(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)，可以幫助考生全面提升備考效果。