+ Reply to Thread
Results 1 to 6 of 6

Complete sheet shows formulas

  1. #1
    Registered User
    Join Date
    10-03-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003
    Posts
    67

    Complete sheet shows formulas

    Hi all
    Here is a newbie question and hope you don't laugh Working on my spread sheet I did something that turned my whole sheet that had value cells to formulasI've tried Ctrl Z to try and to return to where I was but nothing happened I'm nervous that if I start entering more info I may lose all my workAny help or tips would be appreciated.
    Regards

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Complete sheet shows formulas

    If I understand your question well, then the solution will be:

    CTRL + T

    on your sheet.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Complete sheet shows formulas

    hi Treecko. not sure if this is the problem. you can try CTRL + ~
    the tilde icon is on the left of the number 1. that's to show formulas on a sheet. if that doesn't work, attach a sample workbook. Make sure there is just enough data to make it clear what is needed.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  4. #4
    Registered User
    Join Date
    10-03-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Complete sheet shows formulas

    Hi Gang
    Thanks for the tips. I tried the Ctrl T and nothing happened. I've attached my problem. Hope you can help.
    Regards
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Complete sheet shows formulas

    I used CTRL + T (hold it together) on your sheet and get this result.

    See the attached file.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-03-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Complete sheet shows formulas

    Thanks for the help. Much appreciated. Guess I can breath now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Line graph shows flatline because formulas show 0.00 - HELP!!
    By julie0305 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-01-2013, 12:15 PM
  2. cell shows value because the formula is not been complete
    By palmer19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2010, 06:40 AM
  3. worksheet shows dates as number and formulas as formulas
    By baneVader in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2008, 01:36 PM
  4. [SOLVED] help. Excel shows formulas, not answers
    By Klodney in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2006, 10:15 PM
  5. building a reporting sheet which reports by date and shows values of another sheet
    By alymcmorland in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2005, 09:05 AM

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