Excel shortcuts

15 Keyboard Shortcuts to Show Formulas in Excel

Formulas are the key to getting things done in Excel. They're what make it possible to perform complex calculations with just a few clicks. But if you're new to Excel, or if you're not familiar with the many different ways formulas can be used, they can be a bit daunting. That's why we've put together this list of 15 keyboard shortcuts to help you quickly and easily show formulas in Excel.

1. Ctrl+` (Windows) or Option+Fn+F9 (Mac): This shortcut will toggle the display of formulas on and off. If formulas are currently being displayed, they will be hidden. If formulas are currently hidden, they will be displayed.

2. Ctrl+Shift+F3 (Windows) or Option+Fn+F3 (Mac): This shortcut will open the Insert Function dialog box, which can be used to insert a function into a cell. This is a great way to see a list of all the available functions in Excel, as well as get a description of what each function does.

3. Ctrl+= (Windows) or Option+Fn+= (Mac): This shortcut will insert the equal sign (=) into a cell. This is the first step in creating a formula, and is a great way to quickly create a simple formula without having to open the Insert Function dialog box.

4. Ctrl+Shift+U (Windows) or Option+Fn+U (Mac): This shortcut will open the Format Cells dialog box, which can be used to format cells. This is a great way to quickly change the number format of a cell, or to apply other formatting options.

5. Ctrl+Shift+O (Windows) or Option+Fn+O (Mac): This shortcut will open the Conditional Formatting dialog box, which can be used to apply conditional formatting to cells. This is a great way to quickly highlight cells that meet certain criteria, such as cells that contain a value that is greater than or equal to 10.

6. Ctrl+Shift+P (Windows) or Option+Fn+P (Mac): This shortcut will open the Data Validation dialog box, which can be used to validate data in cells. This is a great way to ensure that data entered into cells is in the correct format, such as a date or a number.

7. Ctrl+Shift+A (Windows) or Option+Fn+A (Mac): This shortcut will open the AutoCorrect dialog box, which can be used to automatically correct errors in formulas. This is a great way to quickly fix errors in formulas, such as misspelled function names or incorrect cell references.

8. Ctrl+Shift+R (Windows) or Option+Fn+R (Mac): This shortcut will open the Replace dialog box, which can be used to replace text in formulas. This is a great way to quickly find and replace text in formulas, such as replacing a cell reference with another cell reference.

9. Ctrl+Shift+T (Windows) or Option+Fn+T (Mac): This shortcut will open the Go To dialog box, which can be used to go to a specific cell in a worksheet. This is a great way to quickly jump to a specific cell, such as a cell that contains a formula that you want to edit.

10. Ctrl+Shift+F (Windows) or Option+Fn+F (Mac): This shortcut will open the Find dialog box, which can be used to find text in formulas. This is a great way to quickly find text in formulas, such as a specific cell reference or a function name.

11. Ctrl+Shift+H (Windows) or Option+Fn+H (Mac): This shortcut will open the Replace dialog box, which can be used to replace text in formulas. This is a great way to quickly find and replace text in formulas, such as replacing a cell reference with another cell reference.

12. Ctrl+Shift+J (Windows) or Option+Fn+J (Mac): This shortcut will open the Go To dialog box, which can be used to go to a specific cell in a worksheet. This is a great way to quickly jump to a specific cell, such as a cell that contains a formula that you want to edit.

13. Ctrl+Shift+K (Windows) or Option+Fn+K (Mac): This shortcut will open the Data Validation dialog box, which can be used to validate data in cells. This is a great way to ensure that data entered into cells is in the correct format, such as a date or a number.

14. Ctrl+Shift+L (Windows) or Option+Fn+L (Mac): This shortcut will open the Conditional Formatting dialog box, which can be used to apply conditional formatting to cells. This is a great way to quickly highlight cells that meet certain criteria, such as cells that contain a value that is greater than or equal to 10.

15. Ctrl+Shift+M (Windows) or Option+Fn+M (Mac): This shortcut will open the AutoCorrect dialog box, which can be used to automatically correct errors in formulas. This is a great way to quickly fix errors in formulas, such as misspelled function names or incorrect cell references.

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.