Microsoft Excel Question:
Download Questions PDF

How can I printout the formulas in an Excel spreadsheet - rather than the results?

Answer:

The trick is to change the way Excel displays the worksheet before you choose to print. Check the box Tools, Options, View, Formulas and you'll see the formulas appear in each cell (with the columns changed to fit). When you print the sheet the formulas will be printed instead of the values

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?Is it possible to change the color and font of the sheet tabs?