X
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
This article has been viewed 3,406 times.
This wikiHow teaches you how to use a quick keyboard shortcut to display the formulas in your Excel spreadsheet.
Steps
-
1Open a worksheet that contains formulas. You can usually open a worksheet by double-clicking its file name on your computer.
-
2Press Ctrl+`. This key, called the “grave” accent, is near the top-left corner of the keyboard (to the left of the "1" key. All formulas are now visible.[1]
- You may have to resize the columns to see the entire formula.
-
3Press Ctrl+` again to switch back.
References
About This Article
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 3,406 times.
How helpful is this?
Co-authors: 6
Updated: December 21, 2021
Views: 3,406
Categories: Microsoft Excel
Article SummaryX
1. Open a worksheet.
2. Press Control + `
3. Press it again to switch back.
Did this summary help you?
