工作時更得心應手!上班族必學33個超實用Word、PowerPoint、Excel快捷鍵
省時的方法永不嫌多,快捷鍵多學幾個總是好的。不少上班一族都需要用到Word、PowerPoint、Excel(試算表),熟悉快捷鍵不但能提高工作效率,更能增強職場上的競爭力。現在為大家送上33組超實用快捷鍵,快點學起來吧!
上班族必學33個超實用Excel快捷鍵立即提高工作效率
![工作時更得心應手!上班族必學19個超實用Excel快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-5.16.08_15086477445f0831e9b670f.png)
Word 快捷鍵
1. 粗體
Windows: Ctrl + B
Mac: command+ B
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-19.12.33_119044784461a37694c814f-1024x492.png)
2. 斜體
Windows: Ctrl + I
Mac: command + I
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-19.13.06_194488122861a376a89fba6-1024x462.png)
3. 底線
Windows: Ctrl + U
Mac: command + U
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-19.13.31_50448942561a376b441c02-1024x417.png)
6. 變更字母的大小寫
Windows: Shift + F3
Mac: shift + F3
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-20.33.49_176017671861a37741558d7-1024x708.png)
7.靠左對齊文字
Windows: Ctrl + L
Mac: Command + L
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-20.35.09_113943428961a377908174f-1024x607.png)
8.靠右對齊文字
Windows: Ctrl + R
Mac: Command + R
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-20.37.45_156056689761a3782389958-1024x641.png)
9. 分頁符號
Windows: Ctrl + Enter
Mac: Command + Enter
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-20.41.04_83095673261a378ec7fdb9-1024x727.png)
10.插入註解
Windows: Alt + R or C
Mac: Command + Option + A
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-20.42.37_81763020661a3794cac313-1024x416.png)
PowerPoint 快捷鍵
1.開始投影片放映
Windows: Alt + S
Mac: Command + Return
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-21.01.56_26514640261a37dcda2119-1024x785.png)
2.回到第1張投影片
Windows: Ctrl + Shift + ↑
Mac: Command + Shift + return(enter)
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-21.01.56_124572628161a37e0230d55-1024x785.png)
3.結束投影片放映
Windows: Esc
Mac: Esc
Mac: Command + 句號 or 連字號
4. 插入新的投影片
Windows: 請將指頭放在縮圖窗格中,按 Ctrl + M
Mac: Control + M
Mac: Command + shift + N
![快捷鍵](https://imgs.sundaymore.com/wp-content/uploads/2020/07/-2021-11-28-21.04.21_213924719161a37e5dba751-1024x779.png)
Excel快捷鍵
1.建立一個新檔案
Window:Ctrl + N
Mac:Command + N
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-1.48.04_9679682135f0802dbe4b9b-1024x770.png)
2. 選擇一整列
Window:Shift + Space
Mac:Shift + Space
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-1.48.13_201758275f0802ee6c23c-1024x617.png)
3. 選擇一整欄
Window:Ctrl + Space
Mac:Shift + Space
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-1.48.21_19510530535f08030a754fd.png)
4. 打開儲存格格式
Window:Ctrl + 1
Mac:Command+1
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-1.48.30_7218242085f080320b8094-1024x621.png)
5. 插入新的工作表
Window:Shift + F11
Mac:fn + Shift + F11
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-1.48.37_18677551475f08033279945-1024x440.png)
6. 把表格變成圖表
Window:F11
Mac:F11
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-1.48.43_2714742155f0803543bf44-1024x350.png)
8. 刪除新的欄或列
Window:Ctrl + 減號
Mac:CONTROL + 連字號 / Command+ 連字號
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-1.49.22_10903151975f0803f21a9c9-1024x681.png)
9.計出想要數據的總和
Window:Alt + 等於號
Mac:Option+等於號
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-1.49.41_988074435f08040b28a94-993x1024.png)
10. 加上超連結
Window:Ctrl + K
Mac:command + K
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/excel_011_9963921495b05940d47914.jpg)
11. 在同一個輸入格中開新一行
Window:Alt + Enter
Mac:command + Enter
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/excel_10_18155800565b05940c15772.jpg)
12. 輸入即時日期
Window:Ctrl +;
Mac:command +;
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/excel_01_8554075115b0594005013a.jpg)
13. 輸入即時時間
Window:Ctrl + Shift +;
Mac:command +Shift +;
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/excel_02_3049907455b05940151789.jpg)
14. 轉換成2個位小數的貨幣格式
Window:Ctrl +Shift +$
Mac:command +Shift +$
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/excel_03_15263184495b0594027c1ff.jpg)
15. 隱藏選取的列
Window:Ctrl +9
Mac:command +9
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/excel_04_330594115b059403e3079.jpg)
16. 隱藏選取的欄
Window:Ctrl + 0
Mac:command +0
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/excel_05_3074818065b0594061ccee.jpg)
17. 顯示 / 隱藏公式
Window:Ctrl +~
Mac:Ctrl +~
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/excel_06_6419769395b059407bb043.jpg)
18. 加上外邊框
Window:Ctrl +Shift+&
Mac:Option+shift +&
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/excel_07_13194994335b059408c71b8.jpg)
19. 切換分頁
Window:Ctrl+PageUp / Ctrl+PageDown
Mac:OPTION + 向左鍵/OPTION + 向右鍵
![Excel快捷鍵,Window,Mac,Shift,辦工室,表格,分頁](https://imgs.sundaymore.com/wp-content/uploads/2018/05/nhv4dxh3MJN7gxp/-2020-07-10-1.48.37_7328503545f0828283fb89-1024x440.png)
有什麼餐廳適合慶祝生日或週年紀念?
香港其實有很多特色餐廳,即睇:打卡餐廳Cafe推介/海景餐廳推介/香港酒吧高質推介,適合打卡,又是情侶拍拖、慶祝生日、紀念日,甚至閨蜜聚會的好去處!
有什麼拍拖好去處推介?
情侶約會可以去這拍拖好去處,既玩味又能滿足女生愛打卡的要求。在特別日子到影相好去處拍照留念都是很好的選擇!另外也可到Art Jamming、Tufting,最後可以去按摩店放鬆身心。