Excel is a spreadsheet software written by computer. The intuitive interface, excellent calculation capabilities, and charting tools, combined with successful marketing, make Excel the most popular data processing software for personal computers. Today, the editor of the computer science Xi has prepared 30 commonly used Exce shortcuts for you, which are very practical, remember to collect and forward them after reading!
1. Common Excel operation skills
- Ctrl + C / Ctrl + V:复制&粘贴区域
2. Ctrl + X / Ctrl + V:剪切&粘贴区域
3. Ctrl + Z: Undo the previous operation
4. F4: Repeat the previous command or operation
5. Ctrl + F: Show the Find function menu
2. File operation
6. Ctrl + S:保存工作簿
7. F12: Save Workbook As
8. Ctrl + P:打印
3. Functional area
9. Ctrl + F1: Show or hide the ribbon
10. Alt: Displays shortcut keytips on the ribbon
Fourth, the cells are dragged and dropped
11. Drag & Drop: Cut and paste
12. Ctrl + 拖放:复制并粘贴
13. Shift + 拖放：移动并插入
5. Select a region
14. Ctrl + A: Select the current area or the entire workbook
15. Shift + Click: Select adjacent areas
16. Ctrl + Select: Select an area that is not adjacent
6. Expand the selection area
17. Shift + D-pad: Select an area to expand a cell
18. Ctrl + Shift + D-pad: Select the region to expand to the last non-empty cell
7. Selection & Positioning
19. Ctrl + G: Displays the Positioning menu
20. Alt+;: Select visible cells, use this shortcut to select the visible cells in the current selected range. Hidden row and column cells are not selected.
8. Edit cells
21. F2: Edit the active cell, use this shortcut key to enter the cell editing state, and insert the cursor to the end of the cell content.
22. ESC: Cancel edit, use this shortcut to cancel the edit, edits made before this time will not take effect.
23. Alt + Enter:单元格内换行。
9. Data Entry
24. Ctrl + Enter: Enter the same data in the selected multiple cells
25. Ctrl + D: Copy the previous row of data from the active cell to the active cell.
26. Ctrl + R: Copy the data left of the active cell to the active cell.
27. Alt + ↓: Displays a drop-down list.
10. Excel cell formatting
28. Ctrl + 1: Display the Format Cells menu
11. Excel number format
29、 Ctrl + Shift + ~：应用常规数字格式
30、 Ctrl + Shift + L：打开/关闭自动筛选
How many of these 30 excel shortcuts will you have?
Xi hard!