+ Reply to Thread
Results 1 to 3 of 3

Getting Cells to Show the Formulas Behind their Values

  1. #1
    Registered User
    Join Date
    06-20-2016
    Location
    Wisconsin, USA
    MS-Off Ver
    365 ProPlus
    Posts
    44

    Getting Cells to Show the Formulas Behind their Values

    I have a table filled with values that are the result of some formulas. I know that if you double click in the cell the formula will appear, and then once you hit enter, the formula will go away and the result will appear in the cell.

    My question is: Is there a way for the cells in my table (attached) to only display the formulas, and not the actual values? I.e., I want it so the table shows the formulas behind the value in each cell on its own without me having to double-click in each individual cell.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Getting Cells to Show the Formulas Behind their Values

    Holder Ctrl + ~ keys

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Getting Cells to Show the Formulas Behind their Values

    You didn't ask, but if you'd like a "parallel" table to display the formulas corresponding to the actual values you could see both at the same time.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

+ 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. [SOLVED] can you show formulas in selected cells only of a worksheet?
    By covenantdanes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2013, 10:26 AM
  2. [SOLVED] VBA to enter various formulas every 10 rows and show dynamic formulas not values
    By faby2203 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2013, 07:05 AM
  3. Replies: 1
    Last Post: 03-22-2012, 01:28 PM
  4. [SOLVED] Show cells with formulas without permanently changing the cells
    By DoctorG in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-19-2006, 07:43 AM
  5. [SOLVED] How can I show values, not formulas in Excel?
    By jwbass in forum Excel General
    Replies: 3
    Last Post: 01-12-2006, 12:35 PM
  6. Replies: 2
    Last Post: 09-22-2005, 09:05 PM
  7. AdvancedFilter on cells with formulas, returning values and not formulas
    By Claus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2005, 03:05 PM
  8. How do you show formulas in certain cells only (not the whole she.
    By andy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2005, 03:06 PM

Tags for this Thread

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