To display formulas instead of results in Excel, you can use the shortcut Ctrl + ~. Pressing Ctrl + ~ will toggle between Excel's standard display and the display mode, which shows formulas. This is particularly helpful when you want to check or analyze the underlying formulas in your worksheet.