+ Reply to Thread
Results 1 to 6 of 6

can you show formulas in selected cells only of a worksheet?

  1. #1
    covenantdanes
    Guest

    can you show formulas in selected cells only of a worksheet?

    I am trying to show formulas in certain cells of a worksheet, but not all.
    When I use the ctrl+` command it changes all the cells and not just the ones
    I've selected. Is it possible to only show formulas in selected cells?

  2. #2
    Tom Ogilvy
    Guest

    Re: can you show formulas in selected cells only of a worksheet?

    There is no support for this.

    --
    Regards,
    Tom Ogilvy

    "covenantdanes" <covenantdanes@discussions.microsoft.com> wrote in message
    news:306C73D3-E16F-45D7-B5A3-FED05396DD0E@microsoft.com...
    > I am trying to show formulas in certain cells of a worksheet, but not all.
    > When I use the ctrl+` command it changes all the cells and not just the

    ones
    > I've selected. Is it possible to only show formulas in selected cells?




  3. #3
    Bob Umlas
    Guest

    Re: can you show formulas in selected cells only of a worksheet?

    In the selected cells, use edit/replace, and change "=" to "x=". When you're
    finished viewing/printing them, change "x=" to "="
    (no quotes)
    Bob Umlas
    Excel MVP

    "covenantdanes" <covenantdanes@discussions.microsoft.com> wrote in message
    news:306C73D3-E16F-45D7-B5A3-FED05396DD0E@microsoft.com...
    > I am trying to show formulas in certain cells of a worksheet, but not all.
    > When I use the ctrl+` command it changes all the cells and not just the

    ones
    > I've selected. Is it possible to only show formulas in selected cells?




  4. #4
    David McRitchie
    Guest

    Re: can you show formulas in selected cells only of a worksheet?

    see the user defined functions GetFormula and GetFormulaD in
    http://www.mvps.org/dmcritchie/excel/formula.htm

    Not exactly what you asked for but I think it is much better, because
    you can place these User Defined Functions anywhere on the sheet
    to show representative cells, and you can print the worksheet showing
    actual worksheet with some functions shown.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "covenantdanes" <covenantdanes@discussions.microsoft.com> wrote in message
    news:306C73D3-E16F-45D7-B5A3-FED05396DD0E@microsoft.com...
    > I am trying to show formulas in certain cells of a worksheet, but not all.
    > When I use the ctrl+` command it changes all the cells and not just the ones
    > I've selected. Is it possible to only show formulas in selected cells?




  5. #5
    Registered User
    Join Date
    12-03-2012
    Location
    Doha, Qatar
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: can you show formulas in selected cells only of a worksheet?

    One excellent option in Excel 2007 is to use "ADD WATCH". Using watch window you can basically WATCH any cell anywhere in the whole sheet while you play around with other cells and their values.

  6. #6
    Registered User
    Join Date
    11-09-2012
    Location
    Leeds, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: can you show formulas in selected cells only of a worksheet?

    Enter an apostrophe before the equals sign of your formula. The apostrophe tells Excel to treat the remainder of the cell input as a literal, and will be hidden.

+ 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