Buzz
For professionals, utilizing shortcuts is an art form. Whether you're an accountant or regularly work with Excel, using Excel shortcuts is a must. It greatly enhances productivity, though mastery is key for optimal performance.
Compilation of Excel shortcuts for all versions.
I. Essential Excel shortcuts, most commonly used
| Số thứ tự | Các phím tắt Excel thường được sử dụng | Chức năng |
| 1 | Phím Ctrl + Z | Quay lại bước đã làm trước đó |
| 2 | Ctrl + Y | Chuyển tới bước làm sau cùng |
| 3 | Ctrl + C | Copy nội dung của trong Excel |
| 4 | Ctrl + X | Copy và xóa nội dung của ô được chọn |
| 5 | Ctrl + V | Dán dữ liệu copy vào ô Excel |
| 6 | F2 | Chỉnh sửa ô tính đang đặt con trỏ chuột |
| 7 | Alt + Enter | Xuống dòng trong cùng một ô |
| 8 | Enter | Xuống dòng |
| 9 | Shift + Phím Enter | Di chuyển lên ô phía trên |
| 10 | Tab / Shift + Tab | Chuyển |
| 11 | Esc | Hủy việc sửa trong một ô |
| 12 | Backspace | Xóa ký tự bên trái của con trỏ văn bản, hoặc xóa toàn bộ dữ liệu trong bảng tính được chọn |
| 13 | Phím Delete | Xóa ký tự bên phải của con trỏ văn bản, hoặc xóa toàn bộ dữ liệu trong bảng tính được chọn |
| 14 | Ctrl + Delete | Xóa văn bản đến cuối dòng |
| 15 | Ctrl + Shift + : (dấu hai chấm) | Chèn thời gian hiện tại |
| 16 | Alt + H, A, R | Căn dữ liệu sang phải ô |
| 17 | Alt + H, A, C | Căn dữ liệu ra giữa ô |
| 18 | Alt + H, A, I | Căn dữ liệu sang trái ô |
| 19 | Ctrl + PageDown | Chuyển sang sheet bên trái |
| 20 | Ctrl + W | Đóng bảng tính excel |
| 21 | Ctrl + O | Mở bảng tính excel mới |
| 22 | Ctrl + S | Lưu bảng tính excel |
| 23 | Ctrl + N | Tạo một workbook mới |
| 24 | Ctrl + F4 | Đóng công cụ Excel |
| 25 | Ctrl + ; | Nhập ngày tháng năm vào bảng dữ liệu |
| 26 | Ctrl + Shift + ; | Nhập giờ vào bảng dữ liệu |
| 27 | Alt + A | Chuyển đến tab Data trên thanh công cụ |
| 28 | Alt + W | Chuyển đến tab View trên thanh công cụ |
| 29 | Alt + M | Chuyển đến tab Formula trên thanh công cụ |
Moreover, these common Excel shortcuts can be applied across various software programs. Therefore, it's worthwhile to memorize them as they'll be immensely helpful.
- Learn more: How to create shortcuts in Excel
Top tips for mastering Excel shortcuts
- Limit mouse usage and try to utilize the keyboard as much as possible. While initially unfamiliar, this practice may slow you down at first, but eventually, it will accelerate your operations as you remember and become accustomed to shortcuts.
- Additionally, to swiftly use shortcuts, you need to practice touch typing, not only typing letters but also functional keys, without looking at the keyboard.
- If you're using a laptop, opt for an external keyboard with ample space and responsive keys for easier typing.
II. Advanced Excel shortcuts for working with selected data
1. Shortcut keys for selecting cells in Excel
Ctrl + Space: Selects entire column of data.
Ctrl + Shift + *: Selects the surrounding region of active cells.
Ctrl + A (or Ctrl + Shift + Space): Selects entire Excel worksheet.
Ctrl + Shift + Page Up: Selects current and previous sheet in the same Excel file.
Shift + Page Down / Shift + Page Up: Selects more cells down/up the screen.
Shift + Home: Selects first cells of a row.
Ctrl + Shift + Home: Selects the first cell of the worksheet.
Ctrl + Shift + End: Selects to the last used cell in the worksheet.
2. Excel shortcut keys for managing selections in selected areas
F8: Activates the expand selection feature. After pressing F6, use arrow keys for further selection.
Shift + F8: Adds a range of cells to the selection. Use arrow keys and Shift + arrow keys to add to the selection.
Enter / Shift + Enter: Moves the current cell down or up.
3. Excel shortcut keys for in-cell editing
Shift + left arrow / Shift + right arrow: Select or deselect one character to the left, to the right.
Ctrl + Shift + left arrow / Ctrl + Shift + right arrow: Select or deselect one word to the left, to the right.
Shift + Home / Shift + End: Select from the text cursor to the beginning, to the end of the cell.
III. Excel navigation shortcuts within a worksheet
Page Down / Page Up: Move to the bottom/top of the worksheet.
Alt + Page Down / Alt + Page Up: Scroll right/left within a worksheet.
Tab / Shift + Tab: Move one cell to the right/left within a worksheet.
Home: Move to the first cell of a row within a worksheet.
Ctrl + Home: Move to the first cell of a worksheet.
Ctrl + End: Move to the last cell containing data within a worksheet.
Ctrl + F: Display the Find and Replace dialog (open to the Find tab).
Ctrl + H: Display the Find and Replace dialog (open to the Replace tab).
Shift + F4: Repeat the previous search.
Ctrl + G (or F5): Display the 'Go to' dialog.
Ctrl + left arrow / Ctrl + right arrow: Inside a cell: Move to the cell to the left or right of the current cell.
Alt + down arrow: Show AutoComplete list.
IV. Excel shortcuts for inserting and editing data
1. Excel shortcuts for editing active cells or selections
Ctrl + D: Copy content from the cell above.
Ctrl + R: Copy content from the cell to the left.
Ctrl + ': Copy content from the cell above and enter edit mode.
Ctrl + ': Copy formula from the cell above and enter edit mode.
Ctrl + –: Display delete menu for cell/row/column.
Ctrl + Shift + +: Display insert menu for cell/row/column.
Shift + F2: Insert/Edit a comment.
Shift + F10, then M: Delete comment.
Alt + F1: Create and insert chart with data in the current range.
F11: Create and insert chart with data in the current range on a separate chart sheet.
Ctrl + K: Insert a hyperlink.
Enter (in a cell with a hyperlink): Open the link in the default browser on your computer.
2. Excel Shortcuts for Hiding and Unhiding Elements
Ctrl + 9: Hide selected rows in Excel.
Ctrl + Shift + 9: Unhide rows within the selection containing hidden rows.
Ctrl + 0 (zero): Hide selected columns in Excel.
Ctrl + Shift + 0 (zero): Unhide columns within the selection containing hidden columns.
Note: In Excel 2010, this doesn't work. To unhide a column just hidden, press: Ctrl + Z.
Alt + Shift + right arrow: Group rows or columns.
Alt + Shift + left arrow: Ungroup rows or columns.
V. Excel Shortcuts Related to Data Formatting
1. Excel Cell Formatting Shortcuts
Ctrl + 1: Opens the Format Cells dialog box.
Ctrl + B (or Ctrl + 2): Applies or removes bold font formatting.
Ctrl + I (or Ctrl + 3): Applies or removes italic font formatting.
Ctrl + U (or Ctrl + 4): Applies or removes underline.
Ctrl + 5: Applies or removes strikethrough formatting.
Alt + ' (single quote) : Opens the Style dialog box.
2. Excel Number Formatting Shortcuts
Ctrl + Shift + $: Applies currency format with two decimal places.
Ctrl + Shift + ~: Applies General number format.
Ctrl + Shift + #: Applies date format: day, month, and year.
Ctrl + Shift + @ : Applies time format with hours, minutes, and AM or PM indication.
Ctrl + Shift + ^: Applies scientific number format with two decimal places.
F4: Repeats the last format selection.
3. Excel Shortcuts for Using Formulas
=> Begins a formula.
Shift + F3: Displays the Insert Function dialog box.
Ctrl + A: Displays syntax help after typing a formula name.
Ctrl + Shift + A: Inserts arguments in a formula after typing a formula name.
Shift + F3: Inserts a function as a formula.
Ctrl + Shift + Enter: Enters a formula as an array formula.
F9: Calculates all worksheets in all open workbooks.
Shift + F9: Calculates the active worksheet.
Ctrl + Shift + U: Expands or collapses the formula bar.
Ctrl + ': Toggles between showing formula and value in the cell.
Above are some Excel shortcuts for accountants commonly used to handle various tasks. Additionally, you can explore more Word shortcuts to expedite word processing tasks.
If you frequently log in to Gmail to send emails to friends, business partners, users should also pay attention to Gmail shortcuts to expedite the email composition and sending process in Gmail.
Moreover, there are plenty of Windows 11 keyboard shortcuts that you can explore in the article below.
- Reference: Windows 11 Shortcut List
