38 Excel keyboard shortcuts, Work with Excel faster

When working with table and column data with Excel, the need to use keyboard shortcuts to save time is indispensable.

These keyboard shortcuts are applicable to all versions of Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, and Excel 2019. Please note that an operation can be performed by two other keyboard combinations. each other even though we only knew one before.

Below is a list of common Excel keyboard shortcuts that help quickly format data in Microsoft Excel, please read it for your reference.

Shortcuts to help format cells

1. Ctrl + 1: Display the Format dialog box.
2. Ctrl + B (or Ctrl + 2): Apply or cancel bold formatting.
3. Ctrl + I (or Ctrl + 3): Apply or cancel italic formatting.
4. Ctrl + U (or Ctrl + 4): Apply or cancel an underline.
5. Ctrl + 5: Apply or cancel strikethrough formatting.
6. Alt + '(apostrophe): Display the Style dialog box.

Keyboard shortcuts help in formatting numbers

1. Ctrl + Shift + $: Applies the currency format with two decimal places.
2. Ctrl + Shift + ~: Apply the General number format.
3. Ctrl + Shift + #: Apply date formats like: day, month, and year.
4. Ctrl + Shift + t: Apply the time format with hours, minutes, and indicate AM or PM.
5. Ctrl + Shift + ^: Apply the scientific number format with two decimal places.
6. F4: Repeat last formatting selection.

Shortcuts to help manipulate cells

1. Alt + H, A, R: Align the cell right.
2. Alt + H, A, C: Center the cell.
3. Alt + H, A, I: Align cells to the left.

Formula shortcuts

1. =: Start a formula.
2. Shift + F3: Display the Insert Function dialog box.
3. Ctrl + A: Display input method after entering formula name.
4. Ctrl + Shift + A: Insert arguments in formula after entering formula name.
5. Shift + F3: Insert a function into a formula.
6. Ctrl + Shift + Enter: Enter the formula as an array formula.
7. F9: Counts all worksheets in all workbooks.
8. Shift + F9: Calculate the active spreadsheet.
9. Ctrl + Shift + U: Switch to expand or collapse the formula bar.
10. Ctrl + ': Toggle Show formulas in cells instead of values.
11. Ctrl + Pg Dn (PageDown): The shortcut switches Sheet to sheet right on the open sheet
12. Ctrl + Pg Up (PageUp): Switch to the sheet to the left of the open sheet.
13. Ctrl + arrow keys: move to the top, bottom, left edge, right edge of a worksheet. This shortcut will prevent us from having to use the mouse to drag the slider to find the bottom cell, especially with a long spreadsheet. When you use the Ctrl key with any arrow keys in the direction you want to move, you will quickly get to the position you are looking for.
14. Ctrl + arrow keys + Shift: localize the range of data to the end of the table instead of just moving the selection box to the bottom of the table.
15. Double click the left mouse button in the cell: copy the formula to the bottom of the table. Normal action to copy down the rows below that when appears the + sign, then hold and drag the mouse until the bottom of the table. However, faster, you place the mouse on the plus position, double click the left mouse button and the formula will be copied down.Ctrl + Shift + 1 (!): Format the cell as a decimal number with 2 numbers after the comma.
16. Ctrl + Shift + 4 ($): format currency cell $.
17. Ctrl + Shift + 5 (%): format the cell as number%.
18. F4: turns a cell into absolute value. When copying formulas from different cell locations like B1, C2, . will automatically change when copied to the bottom line to become B2, C3. To prevent the formula from jumping, use the $ key before and after the cell letter to lock it. And a cell can be quickly locked using F4.
19. &: combine two-cell content. Jump to the 3rd column and type the formula = cell 1 & "" & cell 2, in which the "" part to create a space between the contents of 2 cells after merging. Then copy the formula to the bottom of the table, a column will appear with the content of combining columns 1 and 2.
20. Alt + =: quickly sum a column. Highlight the calculated area and highlight 1 blank cell below then press Alt + =, the last cell value is the sum of the cells in the selection.
21. Ctrl + Shift +; (semi-colon): quickly fill the current time in a worksheet.
22. Ctrl +; (semi-colon): enter the current date in the cell.
23. Ctrl + ~ (edge ​​1): see all cells in formulas.

Isabella Humphrey

Update 23 September 2020