How to see formulas on the spreadsheet

Excel 365 2013 2010 2007 2003
Sometimes it is handy to view (and print) the formulas in all the cells in a spreadsheet without having to enter each cell manually.

Press the Ctrl+~ keys to show the formulas in every cell on the worksheet:

See the formulas in Excel 2016

Press the Ctrl+~ keys to return to the standard view:

See the formulas in Excel 2016

See also this tip in French: Comment voir les formules sur la feuille de calcul.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.