Excel shortcuts

25 essential Excel shortcuts for formulas and functions

If you work with Excel on a regular basis, you know that formulas and functions can save you a lot of time and effort. But do you know all the shortcuts that can make working with formulas and functions even easier? In this article, we'll share 25 essential Excel shortcuts for formulas and functions that will help you work faster and more efficiently.

1. Ctrl + Shift + Enter: This shortcut is used to enter an array formula. An array formula is a formula that can perform multiple calculations on one or more sets of data. To use this shortcut, first select the cell or range of cells that you want to enter the formula into. Then, type the formula as you normally would. Finally, press Ctrl + Shift + Enter to complete the formula.

2. Ctrl + A: This shortcut is used to select the entire worksheet. This is helpful if you want to apply a format change or function to the entire sheet. To use this shortcut, simply press Ctrl + A on your keyboard. The entire sheet will be selected.

3. Ctrl + B: This shortcut is used to bold selected text. This is helpful when you want to make a specific word or phrase stand out. To use this shortcut, first select the text that you want to bold. Then, press Ctrl + B on your keyboard. The selected text will be bolded.

4. Ctrl + C: This shortcut is used to copy selected text or cells. This is helpful when you want to duplicate data or move data to another location. To use this shortcut, first select the text or cells that you want to copy. Then, press Ctrl + C on your keyboard. The selected text or cells will be copied.

5. Ctrl + F: This shortcut is used to open the Find dialog box. This is helpful when you want to search for a specific word or phrase. To use this shortcut, press Ctrl + F on your keyboard. The Find dialog box will appear. Type the word or phrase that you want to search for and press Enter.

6. Ctrl + G: This shortcut is used to open the Go To dialog box. This is helpful when you want to quickly jump to a specific cell or range of cells. To use this shortcut, press Ctrl + G on your keyboard. The Go To dialog box will appear. Type the cell address that you want to go to and press Enter.

7. Ctrl + H: This shortcut is used to open the Replace dialog box. This is helpful when you want to find and replace a specific word or phrase. To use this shortcut, press Ctrl + H on your keyboard. The Replace dialog box will appear. Type the word or phrase that you want to find and replace and press Enter.

8. Ctrl + I: This shortcut is used to italicize selected text. This is helpful when you want to make a specific word or phrase stand out. To use this shortcut, first select the text that you want to italicize. Then, press Ctrl + I on your keyboard. The selected text will be italicized.

9. Ctrl + K: This shortcut is used to insert a hyperlink. This is helpful when you want to create a link to another file or website. To use this shortcut, press Ctrl + K on your keyboard. The Insert Hyperlink dialog box will appear. Type the URL or file path that you want to link to and press Enter.

10. Ctrl + N: This shortcut is used to create a new workbook. This is helpful when you want to start a new project or task. To use this shortcut, press Ctrl + N on your keyboard. A new workbook will be created.

11. Ctrl + O: This shortcut is used to open an existing workbook. This is helpful when you want to continue working on a previous project or task. To use this shortcut, press Ctrl + O on your keyboard. The Open dialog box will appear. Select the workbook that you want to open and press Enter.

12. Ctrl + P: This shortcut is used to print a workbook. This is helpful when you want to create a hard copy of a workbook. To use this shortcut, press Ctrl + P on your keyboard. The Print dialog box will appear. Select the printer and settings that you want to use and press Enter.

13. Ctrl + S: This shortcut is used to save a workbook. This is helpful when you want to save your workbook so that you can continue working on it at a later time. To use this shortcut, press Ctrl + S on your keyboard. The Save As dialog box will appear. Select the location where you want to save the workbook and press Enter.

14. Ctrl + U: This shortcut is used to underline selected text. This is helpful when you want to make a specific word or phrase stand out. To use this shortcut, first select the text that you want to underline. Then, press Ctrl + U on your keyboard. The selected text will be underlined.

15. Ctrl + V: This shortcut is used to paste text or cells. This is helpful when you want to duplicate data or move data to another location. To use this shortcut, first select the cell where you want to paste the text or cells. Then, press Ctrl + V on your keyboard. The text or cells will be pasted.

16. Ctrl + W: This shortcut is used to close a workbook. This is helpful when you want to close the workbook that you're currently working on. To use this shortcut, press Ctrl + W on your keyboard. The workbook will be closed.

17. Ctrl + X: This shortcut is used to cut selected text or cells. This is helpful when you want to move data to another location. To use this shortcut, first select the text or cells that you want to cut. Then, press Ctrl + X on your keyboard. The text or cells will be cut.

18. Ctrl + Y: This shortcut is used to repeat the last action. This is helpful when you want to quickly apply the same action to multiple cells or ranges of cells. To use this shortcut, press Ctrl + Y on your keyboard. The last action will be repeated.

19. Ctrl + Z: This shortcut is used to undo the last action. This is helpful when you want to quickly undo a mistake. To use this shortcut, press Ctrl + Z on your keyboard. The last action will be undone.

20. F2: This shortcut is used to edit the selected cell. This is helpful when you want to quickly make a change to a cell. To use this shortcut, press F2 on your keyboard. The cell will be editable.

21. F4: This shortcut is used to toggle the absolute reference. This is helpful when you want to apply a formula to a specific cell or range of cells. To use this shortcut, press F4 on your keyboard. The absolute reference will be applied.

22. F5: This shortcut is used to open the Go To dialog box. This is helpful when you want to quickly jump to a specific cell or range of cells. To use this shortcut, press F5 on your keyboard. The Go To dialog box will appear. Type the cell address that you want to go to and press Enter.

23. F7: This shortcut is used to spell check a workbook. This is helpful when you want to make sure that there are no spelling mistakes in your workbook. To use this shortcut, press F7 on your keyboard. The spell check will begin.

24. F11: This shortcut is used to create a chart. This is helpful when you want to visualize your data. To use this shortcut, select the data that you want to include in the chart. Then, press F11 on your keyboard. A chart will be created.

25. Shift + F3: This shortcut is used to insert a function. This is helpful when you want to quickly insert a function into a cell. To use this shortcut, press Shift + F3

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.