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

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