How to see formulas on the spreadsheet

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

Pressing the Ctrl+~ keys shows the formulas in every cell on the worksheet.

Press the Ctrl+~ keys to return to the normal view.

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