- delete cell
- ctrl -
- altED Edit Delete (2003)
- altHDD Home Delete Delete
- clear cell
- altEAA Edit cleAr All (2003)
- altEAF Edit cleAr Format (2003)
- altEAC Edit cleAr Contents (2003)
- altHEA Home Erase All
- insert cell, insert copied cells
- altIE Insert cEll (2003)
- altHIE Home Insert cEll
- paste special
- altES Edit paste_Special (2003)
- ctrl alt v paste special
- altHVS Home paste Special
- filter
- ctrl shift L turn fiLters on or off
- dff Data Filter autoFilter (2003)
- altAT dAta filTer
- clear filter
- dfs Data Filter S? (2003)
- altAC dAta Clear
- reapply filter
- altAY dAta Y
- advance filter
- dfa Data Filter Advance (2003)
- copy sheet
- altEM Edit Move-or-copy (2003)
- altHOM Home fOrmat Move
- delete sheet
- altEL Edit deLete-sheet (2003)
- altHDS Home Delete Sheet
- rename sheet
- altHOR Home fOrmat Rename
- altOHR fOrmat sHeet Reanme (2003)
- insert sheet
- altIW Insert Worksheet (2003)
- altHIS Home Insert Sheet
- autofit width and height
- altOCA fOrmat Column Autofit (2003)
- altORA fOrmat Row Autofit (2003)
- change width and height
- altOCW fOrmat Column Width (2003)
- altORE fOrmat Row hEight (2003)
- ctrl ; input today
- ctrl shift ; input current time
- ctrl [↑↓←→] ctrl home ctrl end move to non-empty cell
- alt = insert SUM formula
- change to % format
- ctrl shift %
- background color
- altHH Home H
- refresh
- altARA dAta Refresh All
- save as
- F12
- repeat action
- F4
Both altE | alt E can work
- E for Edit
- I for Insert
- D for Data
- O for fOrmat
Alt+DP C N I N (選範圍) Enter Enter
- Alt+D P 開啟舊的 pivote table wizard
- 選「多重彙總資料範圍」 -> 下一步
- 「我會自行建立分頁欄位」 -> 下一步
- 選擇 Table 範圍 -> 下一步 -> 完成
- 集中做完 unpivot 的資料