Excel is a powerful tool that can help you manage and analyze data with ease. However, navigating through the various menus and options can be time-consuming. That’s where keyboard shortcuts come in handy. In this article, we’ll cover 35 Excel shortcut keys that you need to know to save time and increase your productivity.
Navigation Shortcuts
1. Move to the next cell
Press the Tab key to move to the cell to the right of the current cell.
2. Move to the previous cell
Press Shift + Tab to move to the cell to the left of the current cell.
3. Move to the next row
Press Enter to move to the cell directly below the current cell.
4. Move to the previous row
Press Shift + Enter to move to the cell directly above the current cell.
5. Move to the beginning of the row
Press Home to move to the beginning of the current row.
6. Move to the end of the row
Press End to move to the end of the current row.
7. Move to the beginning of the column
Press Ctrl + Home to move to the beginning of the current column.
8. Move to the end of the column
Press Ctrl + End to move to the end of the current column.
Selection Shortcuts
9. Select the entire row
Press Shift + Spacebar to select the entire row of the current cell.
10. Select the entire column
Press Ctrl + Spacebar to select the entire column of the current cell.
11. Select the entire worksheet
Press Ctrl + A to select the entire worksheet.
12. Select a range of cells
Click on the first cell of the range, hold down the Shift key, and click on the last cell of the range to select all the cells in between.
13. Select non-adjacent cells
Hold down the Ctrl key and click on each cell you want to select.
Editing Shortcuts
14. Copy a cell
Press Ctrl + C to copy the contents of the current cell.
15. Cut a cell
Press Ctrl + X to cut the contents of the current cell.
16. Paste a cell
Press Ctrl + V to paste the contents of the clipboard into the current cell.
17. Undo an action
Press Ctrl + Z to undo the last action.
18. Redo an action
Press Ctrl + Y to redo the last action.
19. Insert a new row
Press Ctrl + Shift + + (plus sign) to insert a new row above the current row.
20. Insert a new column
Press Ctrl + Shift + + (plus sign) to insert a new column to the left of the current column.
21. Delete a row
Press Ctrl + – (minus sign) to delete the current row.
22. Delete a column
Press Ctrl + – (minus sign) to delete the current column.
Formatting Shortcuts
23. Bold text
Press Ctrl + B to bold the selected text.
24. Italicize text
Press Ctrl + I to italicize the selected text.
25. Underline text
Press Ctrl + U to underline the selected text.
26. Apply strikethrough formatting
Press Ctrl + 5 to apply strikethrough formatting to the selected text.
27. Apply superscript formatting
Press Ctrl + Shift + + (plus sign) to apply superscript formatting to the selected text.
28. Apply subscript formatting
Press Ctrl + = (equal sign) to apply subscript formatting to the selected text.
29. Change the font size
Press Ctrl + Shift + > (greater than sign) to increase the font size of the selected text.
30. Change the font size
Press Ctrl + Shift + < (less than sign) to decrease the font size of the selected text.
Formula Shortcuts
31. Insert a formula
Press = (equal sign) to start a formula in the current cell.
32. AutoSum a range of cells
Press Alt + = (equal sign) to insert the SUM function for the selected range of cells.
33. Edit a formula
Press F2 to edit the formula in the current cell.
34. Copy a formula
Press Ctrl + D to copy the formula from the cell above the current cell.
35. Fill a formula down
Press Ctrl + R to fill the formula from the cell to the left of the current cell.
By using these Excel shortcut keys, you can save time and increase your productivity. Whether you’re navigating through a large worksheet or editing formulas, these shortcuts will help you work more efficiently. Try incorporating these shortcuts into your Excel workflow and see how much time you can save!
