Microsoft Excel Interview Questions and Answers
Ques. How can I printout the formulas in an Excel spreadsheet - rather than the results?Ans. 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.
Is it helpful? Yes No
Most helpful rated by users: