35 Excel Shortcut Keys You Need to Know – Causal

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.

Xem ngay:  Vòng san hô đỏ mệnh gì? Cách lựa chọn phù hợp, hiệu quả 2023

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.

Xem ngay:  10 Mẫu Vẽ Túi Xách Lớp 9 đẹp Cho Các Bé Tập Tô - MN Tien Thang

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!