Excel表格的35招必學(xué)秘技_很實(shí)用.pdf

Excel表格的35招必學(xué)秘技_超級(jí)實(shí)用

目錄

一、讓不同類(lèi)型數(shù)據(jù)用不同顏色顯示...........................................................................1

二、建立分類(lèi)下拉列表填充項(xiàng).......................................................................................2

三、建立“常用文檔”新菜單...........................................................................................2

五、用“視面管理器”保存多個(gè)打印頁(yè)面...................................................................3

六、讓數(shù)據(jù)按需排序.......................................................................................................3

七、把數(shù)據(jù)徹底隱藏起來(lái)...............................................................................................3

八、讓中、英文輸入法智能化地出現(xiàn)...........................................................................4
九、讓“自動(dòng)更正”輸入統(tǒng)一的文本...........................................................................4
十、在Excel中自定義函數(shù).............................................................................................4
十
一、表頭下面襯張圖片...............................................................................................4
十
二、用連字符“&”來(lái)合并文本.................................................................................4
十
四、Excel幫你選函數(shù).................................................................................................5
十
五、同時(shí)查看不同工作表中多個(gè)單元格內(nèi)的數(shù)據(jù)...................................................5
十
六、為單元格快速畫(huà)邊框...........................................................................................5
十
七、控制特定單元格輸入文本的長(zhǎng)度.......................................................................6
十
八、成組填充多張表格的固定單元格.......................................................................6
十九、改變文本的大小寫(xiě)...............................................................................................6
二十、提取字符串中的特定字符...................................................................................7
二十
一、把基數(shù)詞轉(zhuǎn)換成序數(shù)詞...................................................................................7
二十
二、用特殊符號(hào)補(bǔ)齊位數(shù).......................................................................................7
二十
三、創(chuàng)建文本直方圖...............................................................................................7
二十
四、計(jì)算單元格中的總字?jǐn)?shù)...................................................................................8
二十
五、關(guān)于歐元的轉(zhuǎn)換...............................................................................................