How to see formulas on the spreadsheet

Excel 2016 2013 2007 2003
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.