別說你懂Excel：500招玩轉(zhuǎn)Excel表格與數(shù)據(jù)處理

第1章 Excel 2010快速入門操作技巧
1.1 界面管理與優(yōu)化技巧 ······················· 1
001招 改變快速訪問工具欄的位置 ···············1
002招 在快速訪問工具欄中添加/刪除按鈕 ···1
003招 將功能區(qū)的按鈕添加到快速
訪問工具欄 ········································2
004招 如何隱藏/顯示功能區(qū) ·························2
005招 如何新建常用工具組 ··························3
006招 啟用/禁用消息欄上的安全警報(bào) ··········4
007招 顯示/隱藏屏幕提示 ····························5
008招 如何加載“開發(fā)工具”選項(xiàng)卡 ···········5
009招 如何加載Excel的選項(xiàng)功能 ·················5
010招 禁止顯示浮動(dòng)工具欄 ··························6
011招 更改Excel網(wǎng)格線的顏色 ·····················6
012招 解決Excel無滾動(dòng)條的問題 ·················7
013招 如何設(shè)置編輯欄的隱藏/顯示 ··············7
1.2 新建、保存、打開與關(guān)閉工作簿技巧 ··· 7
014招 根據(jù)現(xiàn)有內(nèi)容創(chuàng)建工作簿 ··················8
015招 如何從樣本模板文件創(chuàng)建新的工作簿 ···8
016招 如何更改默認(rèn)保存工作簿的位置 ········9
017招 如何讓Excel低版本能打開
Excel 2010格式的表格 ······················9
018招 加密保存工作簿 ·······························10
019招 設(shè)置工作簿定時(shí)自動(dòng)保存 ················10
020招 如何以“只讀”方式打開工作簿 ······11
021招 啟動(dòng)Excel時(shí)自動(dòng)打開特定的工作簿 ···11
022招 如何快速打開最近訪問的工作簿 ······12
023招 如何清除打開文件記錄 ····················12
1.3 視圖查看與窗口縮放技巧 ···············13
024招 如何調(diào)整多出的行列打印在同一頁(yè) ···13
025招 自定義工作表視圖 ···························13
026招 如何顯示自定義視圖 ························14
027招 快速調(diào)整文檔的顯示比例 ················14
第2章 數(shù)據(jù)的錄入與編輯技巧
2.1 定位單元格的技巧 ··························15
028招 使用定位命令定位活動(dòng)單元格 ·········15
029招 快速選擇包含數(shù)據(jù)的單元格區(qū)域 ······16
030招 使用“定位條件”快速查找
數(shù)據(jù)有效性區(qū)域 ·······························16
031招 使用“查找”定位常量區(qū)域 ·············17
2.2 數(shù)據(jù)的錄入技巧 ·····························17
032招 為輸入的數(shù)據(jù)自動(dòng)添加小數(shù)位 ·········17
033招 輸入以0開頭的數(shù)字編號(hào) ··················18
034招 輸入貨幣符號(hào) ··································18
035招 使用鍵盤快速輸入“歐元”符號(hào) ······19
036招 快速輸入百分號(hào) ·······························19
037招 輸入身份證號(hào)碼 ·······························20
038招 快速輸入分?jǐn)?shù) ··································20
039招 使用快捷鍵向下填充內(nèi)容 ················ 21
040招 使用軟鍵盤快速輸入℃符號(hào) ············· 21
041招 設(shè)置單元格數(shù)字有效輸入范圍 ·········22
042招 為單元格添加序列選項(xiàng) ····················22
043招 設(shè)置單元格中日期或時(shí)間的
有效性 ·············································23
044招 設(shè)置單元格中保留的文本長(zhǎng)度 ·········23
045招 對(duì)單元格區(qū)域設(shè)置輸入提示信息 ······24
046招 對(duì)單元格中輸入錯(cuò)誤的數(shù)據(jù)
設(shè)置出錯(cuò)警告 ··································24
047招 如何在單元格中圈釋無效數(shù)據(jù) ·········25
048招 快速為其他單元格的數(shù)據(jù)
設(shè)置相同的有效性 ··························25
049招 使用“查找”功能快速搜索數(shù)據(jù) ······26
050招 使用“替換”功能快速對(duì)內(nèi)容
進(jìn)行更改··········································27
2.3 數(shù)據(jù)的填充技巧 ·····························27
051招 快速輸入等差序列數(shù)據(jù) ····················27
052招 自動(dòng)填充步長(zhǎng)值為2的等比序列 ········28
053招 添加自定義填充序列提高輸入速度 ···28
054招 如何將填充柄隱藏 ···························29
055招 同時(shí)在多個(gè)單元格中輸入相同數(shù)據(jù) ···30
2.4 數(shù)據(jù)的編輯技巧 ·····························30
056招 快速將文本數(shù)據(jù)轉(zhuǎn)換為數(shù)字格式 ······31
057招 將單元格區(qū)域公式轉(zhuǎn)化為數(shù)值的方法 ····31
058招 快速刪除單元格內(nèi)容及格式 ·············32
059招 將數(shù)據(jù)復(fù)制為圖片格式 ····················32
060招 快速減少小數(shù)位數(shù) ···························33
061招 快速合并/拆分單元格 ·······················33
062招 在Excel中制作垂直標(biāo)題 ··················34
063招 隱藏單元格中的內(nèi)容 ························34
2.5 單元格、行/列的編輯技巧 ··············35
064招 如何設(shè)置單元格內(nèi)容自動(dòng)換行 ·········35
065招 快速插入單元格 ·······························36
066招 快速插入連續(xù)的多行/多列 ···············37
067招 對(duì)多行/列數(shù)據(jù)進(jìn)行移動(dòng) ···················37
068招 設(shè)置行/列最合適的行高/列寬 ···········38
069招 將聯(lián)系電話分列為“區(qū)號(hào)”和
“號(hào)碼”··········································39
2.6 批注與超鏈接的應(yīng)用技巧 ···············40
070招 在值為0的單元格中