24種 EXCEL技巧實用功能，職場使用專業快速鍵！ |

Working in any company, using an office computer will definitely encounter Excel software, and when using Excel, the general public will use the most primitive way to create files, and the work efficiency is certainly quite low, in Office Excel tips in fact there are quite a lot of quick ways, but we do not use it, and it can be said that the general public may not even know that these key functions exist, previously there was also an introduction [teaching] Word merge print columns when setting the decimal point limit, today small series will teach everyone how to learn these quick and professional keys in the workplace, so that the boss praises, so that colleagues are amazed, and make themselves more valuable (as if a bit exaggerated...), let's continue to see what quick keys are worth learning.

EXCEL技巧專業快速鍵教學

EXCEL Skills Tutorial 1: Advanced Copying Formulas

▼ Press [ctrl] + [R] on the cell to copy the formula in the left column.

EXCEL技巧教學2:一秒瞬間跳至最後欄位

▼ 如果想要跳至欄位最後一筆，可以直接按下【Ctrl】+【鍵盤 ↑ ↓ ← →】就會馬上跳至資料最尾端。

EXCEL skills tutorial 3: Advanced selection of desired fields

▼ If you want to select a whole column or row, you can directly press [Ctrl] + [Shift] + [Keyboard ↑ ↓ ← →] to select all data in the column/row.

EXCEL Skills Tutorial 4: Automatic Text Column Changing Function

▼ 很多使用者不知道如何讓表格中的文字在超出儲存格的寬度後自動換列，其實只要點選「常用」>「對齊方式」功能中的【自動換列】就可以達到這樣的換行效果了。。

EXCEL skills tutorial 5: Generate charts in one second

▼ 如果想要將資料表中的數據變成圖表，只要按下【F11】一秒變圖表。

EXCEL Skills Tutorial 6: Copy the above formula in one second

▼ 在儲存格上按下【ctrl】+【D】就可以複製上方欄位的公式。

EXCEL技巧教學7:秒套用貨幣、百分比格式

▼ 如果想要讓儲存格內的數字格式馬上套用變換的話，按下【Ctrl】+【Shift】+【$】該儲存欄位就會套用「貨幣」格式，而按下【Ctrl】+【Shift】+【%】該儲存欄位就會套用「百分比」格式。。

EXCEL skills teaching 8: multi-function copy and paste

▼ 在想要複製貼上的儲存格上按下【Ctrl】+【Alt】+【V】就會有選擇性貼上的視窗跳出讓使用者選擇需要貼上的是公式、格式或文字。

EXCEL Skills Tutorial 9: Quickly Switch Worksheets

▼ 如果想要快速切換工作表的話，可以直接按下【Ctrl】+【PageUp】或【PageDown】就會發現可以自由的切換工作表。

EXCEL技巧教學10:一秒開起儲存格格式

▼ If you want to quickly change the cell format, press [Ctrl] + [!] to immediately access the "Cell Format" settings.

EXCEL skills tutorial 11: Select all data

▼ If you want to select all the data, just press [Ctrl] + [A] to select all the data.

EXCEL Skills Tutorial 12: Make bold text in one second

▼ 如果要將儲存格的字體粗細改變，只要按下【Ctrl】+【B】就可以讓儲存格內的字體變「粗體字」。

EXCEL Skills Tutorial 13: Add Columns/Columns in Seconds

▼ To insert a new column/row, simply press [ctrl] + [+] to add a column or [ctrl] + [–] to delete a column.

EXCEL Skills Tutorial 14: Table Column/Column Exchange

▼ If you want to swap columns/rows in a data table, select [Transpose] when pasting with the right mouse button to see the table's columns/rows switched.

EXCEL Skills Tutorial 15: Professional Shortcuts

▼ Select the range of content you want to copy, enter the text or formula you want to display, and press [Ctrl] + [Enter] to copy all content into the range.

EXCEL Skills Tutorial 16: Insert date/time in one second

▼ To insert the current time and date, simply press [Ctrl] + [;] to insert the date, and press [Ctrl] + [:] to insert the current time.

EXCEL Skills Tutorial 17: Adding Values with One Click

▼ Press and hold [Alt] + [=] to instantly calculate the total amount shown above.

EXCEL Skills Tutorial 18: Switch Number Format with One Click

▼ 使用 Ctrl + Shift + 數字鍵，可以自由切換為所需要的格式。

CRTL + SHIFT + ` |預設格式
CTRL + SHIFT + 1 |整數
CTRL + SHIFT + 2 |0:00AM/PM 時間格式
CTRL + SHIFT + 3 |1-JAN-00 日期格式
CTRL+SHIFT+4 | Currency format
CTRL + SHIFT + 5 | Percentage format
CTRL + SHIFT + 6 |科學記數格式

EXCEL Skills Tutorial 19: F4 Functions You Don’t Know

▼ F4 It actually has a "repeat last step" function. No matter if it's font, color, indentation, or format, just select another table and press [F4] to automatically repeat the previous action. This command can be used for all table operations, and can be repeated using the [F4] key.