Excel: 数据处理时常用的快捷键
Excel 常用 数据处理 快捷键
2023-06-13 09:12:58 时间
文章背景:Excel的快捷键可以帮助我们提高数据分析的效率。下面介绍在Excel中常用的一些快捷键。
The list is by no means exhaustive. If different, Mac shortcuts are listed in second position.
(1)基本操作
- Undo/Redo CTRL+Z and CTRL+Y | CMD+Z or CMD+Y. Z stands for undo and Y for redo.
- New File/ New Workbook CTRL+N | CMD+N
- Open file / Open Workbook CTRL+O | CMD+O To open the dialogue box and select an existing file (workbook)
- Close file / Close Workbook CTRL+W | CMD+W
- Save file / Save Workbook CTRL+S | CMD+S
- Select all CTRL+A | CMD+A
- Enter a new line of Text ALT + Enter Sometimes when entering data into a cell, you may want to go to a new line below your current one, within the same cell.
- Moving around the worksheet
- Page Up and Page Down will move one "page" (the number of rows shown on the screen) up or down.
- CTRL+arrow keys will move to the next blank cell in that direction.
- CTRL+Home takes you to the first cell that contains data in the top-left corner of the sheet.
- CTRL+End goes to the last cell in the bottom-right.
(2)公式计算
- F4 (fn + F4 / CMD + T) — Cycle through all 4 types of cell references. (Absolute, Mixed x2, Relative)
- SHIFT + F3 (CTRL + A) — Open Formula Builder/ Function Wizard
- CTRL + PgUp (CMD + PgUp) — Go to the previous sheet.
- CTRL + PgDn (CMD + PgDn) — Go to the next sheet.
(3)单元格格式
- CTRL + SHIFT + & (CMD + OPTION + 0) -- Add a border around the outside of selected cells
- CTRL + B (CMD + B) -- Change selection to Bold Text
(4)数据处理
- CTRL + 0 (CMD + 0) -- Hide the column containing the selected cell.
- CTRL + 9 (CMD + 9) -- Hide the row containing the selected cell.
- CTRL + SHIFT + 0 (CMD + SHIFT + 0) -- Unhide the column containing the selected cell. (Select cells surrounding hidden column)
- CTRL + SHIFT + 9 (CMD + SHIFT + 9) -- Unhide the row containing the selected cell. (Select cells surrounding hidden row)
- CTRL + SHIFT + L (CMD + SHIFT + F) -- Add or remove a filter
(5)表格打印
- CTRL + P | CMD + P: Open Print dialogue
- CTRL + X | CMD + X: Cut selection
- CTRL + C | CMD + C: Copy selection
- CTRL + V | CMD + V: Paste data (from previous cut/copy action)
- CTRL + F2: Open Print Preview window
参考资料:
[1] Excel Skills for Business: Essentials(https://www.coursera.org/learn/excel-essentials?)
延伸阅读:
[1] Windows Shortcuts: Microsoft Office Support pages(https://support.office.com/en-us/article/Excel-keyboard-shortcuts-and-function-keys-for-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f?ui=en-US&rs=en-US&ad=US)
[2] Mac Shortcuts: Microsoft Office Support pages(https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd)
相关文章
- pycharm界面颜色设置_Excel护眼色打印
- java实现在线预览–poi实现word、excel、ppt转html
- csv格式怎么转成excel_比较好一点的Excel转PDF
- Excel AVB之Dir
- excel导入mysql代码_EXCEL导入Mysql方法「建议收藏」
- 图片链接如何在excel里转成图片_mdf文件怎么转成Excel
- 常用的三种办公软件,也就是office三件套excel、word、ppt
- excel表格安装包下载完整版教程
- Python实现批量上传excel
- python3 pandas 读取 Excel、CSV
- Python 接口测试之Excel表格数据操作方法封装
- 通过Excel生成批量SQL语句详解编程语言
- 数据库快速实现Excel导入MySQL数据库(excel导入mysql)
- 利用mongodb快速导出Excel文件(mongodb导出excel)
- 数据快速导出Excel:从MySQL中快速获取数据(excel导出mysql)
- 利用Excel快速连接MySQL数据库(excel连接mysql)
- MySQL数据导出Excel快速教程(mysql转excel)
- 步骤简单!轻松实现SQL Server导入Excel操作(sqlserver导入excel)
- Excel与Oracle精准大数据统计分析利器(excel和oracle)
- php中使用ExcelFileParser处理excel获得数据(可作批量导入到数据库使用)
- php读取EXCEL文件phpexcelreader读取excel文件
- js导出table数据到excel即导出为EXCEL文档的方法
- VBA中操作Excel常用方法总结