+ Reply to Thread
Results 1 to 3 of 3

HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET

  1. #1
    Vanessa
    Guest

    HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET

    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?

  2. #2
    Ian P
    Guest

    RE: HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET

    Try Tools>Options and then select the View tab and tick the formulas box.
    This will display the formula and not the result.

    Ian

    "Vanessa" wrote:

    > 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?


  3. #3
    Alok
    Guest

    Re: HOW DO I DISPLAY FORMULA CONTENTS ON A SPREADSHEET

    A keyboard short cut is Ctrl-~ (that is Control Tilde)

    Alok

    Vanessa wrote:
    > 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?



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1