HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with addition of several numbers in one cell. How can I
display these numbers and print them instead of the final value?
 
Try Tools>Options and then select the View tab and tick the formulas box.
This will display the formula and not the result.

Ian
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell shows the last typed text, no matter where it is typed 0
Cells only display a maximum number of text characters 4
Counting Results of Formulas 1
#N/A In Cells 7
How do I print formulas in a spreadsheet? 4
Chronological Numbering 4
Modify number display 4
How do I combine information from two separate spreadsheets 2

Back
Top